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?
Go to 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")
View solution in original post
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!