not a number

2 Topics

What text values are available for a numerical field? i.e. NaN or #N/A?
Hello, We have a fairly complex DAX formula which returns a numerical value. This works 99% of the time. There are specific instances where - due to underlying data - we cannot calculate a result. In these instances, we'd like to return a text value to notify users that 'this cannot be calculated'. Are there any text values like NaN or #N/A that can be returned in a DAX function which returns a number? If so, what are those 'text' values? Ex. If(a<0, NaN, a) Appreciate any help you can provide. Thanks, Dan
Solved
dancarr22
2 years ago Place DAX Commands and Tips
695Views
0likes
2Comments
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
Solved
Anonymous
3 years ago Place DAX Commands and Tips
1.2KViews
0likes
2Comments