Validate

[gauravnarchal]

Hello

How can I create a measure to validate the column?

If CODE is a number return Valid and if alphanumeric  return Not Valid.

I want to achieve this through the measure, is it possible?

Code

123456789

342424224

24243423FEF3

SD123133131

21231313

EFWE333324

[freginier · Accepted solution]

Why do you want to use a Measure ? 

I think you need to create a calculated column to define if it's valid or not and then do calculation with measure

Column = IF( ISERROR(VALUE('Table'[Column1])),"not valid","valid")