Forum Discussion

InsightSeeker's avatar
InsightSeeker
Helper III
2 years ago
Solved

Validation of Numeric Values Using DAX in Power BI

Hello,   I need help with validating values using DAX to determine if they contain only numeric values.   If the value contains only numeric values, it should return TRUE; otherwise, it should re...
Need Help
Show and Tell
  • danextian's avatar
    danextian
    2 years ago

    hi InsightSeeker ,

     

    You can use VALUE function and ISERROR to check whether the text returns a number.

    Test = 
IF ( NOT ( ISERROR ( VALUE ( 'Table'[Value] ) ) ), TRUE (), FALSE () )

     

danextian's avatar
danextian
Super User
2 years ago

hi InsightSeeker ,

 

You can use VALUE function and ISERROR to check whether the text returns a number.

Test = 
IF ( NOT ( ISERROR ( VALUE ( 'Table'[Value] ) ) ), TRUE (), FALSE () )