Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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