Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dancarr22
Helper V
Helper V

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

1 ACCEPTED SOLUTION
ChiragGarg2512
Super User
Super User

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

View solution in original post

2 REPLIES 2
dancarr22
Helper V
Helper V

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

ChiragGarg2512
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors