Hello. I have a prior year formula in Dax that is as follows CALCULATE([Claims Count], DATEADD(Calendar[Date],-1,Year)) I use that as input into cpct sakes growth:=([Claims Count]-[1yearback])/[1yearback]
I'm getting #num errors in fields where there is no prior year. How do I just make blanks? Thanks.
https://msdn.microsoft.com/en-us/library/ee634765.aspx
Are you familiar with google? LoL
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thanks Megatron!! I actually figured out another way using the blank() function. The IFerror is a little dangerous imo. Gracias.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks