topic Re: What text values are available for a numerical field? i.e. NaN or #N/A? in DAX Commands and Tips

What text values are available for a numerical field? i.e. NaN or #N/A?

dancarr22 — Tue, 03 Oct 2023 23:26:32 GMT

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

Re: What text values are available for a numerical field? i.e. NaN or #N/A?

ChiragGarg2512 — Wed, 04 Oct 2023 03:35:22 GMT

dancarr22 , The expression NaN is used for signifying if there has been a division by zero. Blank() or any string value can be used.

Re: What text values are available for a numerical field? i.e. NaN or #N/A?

dancarr22 — Wed, 04 Oct 2023 16:28:47 GMT

Thanks ChiragGarg2512 ! Cool that we can return text in a number field.