Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |