Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Tips and Tricks
  • Smauro's avatar
    Smauro
    8 years ago

    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! :)

freder1ck's avatar
freder1ck
Kudo Kingpin
8 years ago

David,

For a quick solution, try Keep Only Numbers in Power Query post by Ken Puls as a new column and then compare with existing column to see if it's the same length. I think there may be a way to use List.Difference and a list of alpha characters, but that would take a bit more thought...

 

Fred