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

[dancarr22]

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

[dancarr22]

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

[ChiragGarg2512 · Accepted solution]

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