Forum Discussion
InsightSeeker
Helper III
Helper IIIValidation 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 return FALSE.
| Value |
| [email protected] |
| 16546854 |
| 464213 |
| 1641654 |
| 564646 |
| 646464 |
| 546498 |
| 46464 |
| 64646464 |
| 646486 |
| 64646546 |
| ASW4646464 |
| AW54646 |
| AQ464654 |
| AD446464 |
| AS4646DD |
| ASDSWSD |
| KLHH |
| OJOJ |
| POJPOJP |
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 () )
1 Reply
- danextian
Super User
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 () )