Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
InsightSeeker
Helper III
Helper III

Validation of Numeric Values Using DAX in Power BI

‎08-02-2024 04:36 AM

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
gtest@gmail.com
16546854
464213
1641654
564646
646464
546498
46464
64646464
646486
64646546
ASW4646464
AW54646
AQ464654
AD446464
AS4646DD
ASDSWSD
KLHH
OJOJ
POJPOJP
Labels:
Message 1 of 2
228 Views
0
1 ACCEPTED SOLUTION
danextian
Super User
Super User

‎08-02-2024 04:41 AM

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_0-1722598885957.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

Message 2 of 2
221 Views
1 REPLY 1
danextian
Super User
Super User

‎08-02-2024 04:41 AM

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_0-1722598885957.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 2 of 2
222 Views

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All