Forum Discussion
Solved
Checking a column for alpha and alpha numeric characters
Hello, I am relatively new to power bi so please be patient. I am trying to audit data and flag rows that are not all numeric. Here is a sample of my data Phone Number __________...
You can use the Value function together with IsError.
Like this:
IsNum = NOT(ISERROR(VALUE([Phone])))
If you want to alow dahes between the numbers you can add a SUBSTITUTE function around the [Phone] field.
IsNum = NOT(ISERROR(VALUE(SUBSTITUTE([Phone];"-";""))))
Hope this helps.
waltheed
Impactful Individual
Impactful IndividualYou can use the Value function together with IsError.
Like this:
IsNum = NOT(ISERROR(VALUE([Phone])))
If you want to alow dahes between the numbers you can add a SUBSTITUTE function around the [Phone] field.
IsNum = NOT(ISERROR(VALUE(SUBSTITUTE([Phone];"-";""))))
Hope this helps.
Thank you very much!