Forum Discussion
Check whether characters are numeric
I have a list of shipping confirmation numbers, but some of them are entered incorrectly. I want to create a calculated column that checks for various conditions. One of those conditions is whether t...
Another one, using DAX, could be:
NumericCheck = VAR x = MOD ( [Shipping], 2 ) RETURN IF ( ISERROR ( x ), "Correct", "Numeric" )
Which basically first tries to do some math with the row, and if succeeds the value is Numeric.
This would work similarly with any math operation:NumericCheck2 = VAR x = ( [Shipping] - 2 ) RETURN IF ( ISERROR ( x ), "Correct", "Numeric" )
I hope this helps! :)
And If I want to use this DAX measure and do not consider the Blank how can below be modified?
ISERROR ( VALUE ( Table1[Column1] ) )