Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
2 years ago
Solved

Validate Columns

Hello - How can I create a measure or column to validate all the columns of a table as

 

If Column 1 is not blank and contains 3 characters    &

If Column 2 is not blank and contains 3 characters    &

If Column (Date) is not blank and contains a date    & 

If Column (Time 1) is not blank and contains time    & 

If Column (Time 2) is not blank and contains time 

 

If all columns are validated return Valid else Invalid.

 

Table Name - Validation

Column 1Column 2DateTime 1Time 2
APPBAN26-Jan-2415:0001:00
APP 26-Jan-2415:0001:00
APPBAN 15:0001:00
APPBAN26-Jan-2415:0001:00
APPBAN26-Jan-24 01:00
APPBAN26-Jan-2415:00