Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hello please I need your help on this, How can I check if the column has an alphabet, let's say I need to add a new column that returns False if it has an alphabet here is an example
Solved! Go to Solution.
@toum you need a white list and a measure like this
Measure =
VAR curr =
MAX ( 'Table'[Column1] )
RETURN
IF (
ISBLANK (
CALCULATE (
MAX ( num[alphabets] ),
FILTER ( num, CONTAINSSTRING ( curr, num[alphabets] ) )
)
)
= TRUE (),
TRUE (),
FALSE ()
)
@toum you need a white list and a measure like this
Measure =
VAR curr =
MAX ( 'Table'[Column1] )
RETURN
IF (
ISBLANK (
CALCULATE (
MAX ( num[alphabets] ),
FILTER ( num, CONTAINSSTRING ( curr, num[alphabets] ) )
)
)
= TRUE (),
TRUE (),
FALSE ()
)
Thank you, but do I have to create a table num!
Yes
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.