Forum Discussion
Nan Error
Jolly Day,
Newer to power BI and am getting a NaN error with the below formula. I need to add an if statement I believe but am not sure how to implement it. Could I get some help with this?
S Daily Average = CALCULATE(Audit[SUM prozacs]/MAX('Working Days'[Working Days]) + 0)
Many thanks,
Lydia
You use the DIVIDE function in this case:
https://learn.microsoft.com/en-us/dax/best-practices/dax-divide-function-operator
2 Replies
You use the DIVIDE function in this case:
https://learn.microsoft.com/en-us/dax/best-practices/dax-divide-function-operator