The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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