Validate Columns

[gauravnarchal]

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 1	Column 2	Date	Time 1	Time 2
APP	BAN	26-Jan-24	15:00	01:00
APP		26-Jan-24	15:00	01:00
APP	BAN		15:00	01:00
APP	BAN	26-Jan-24	15:00	01:00
APP	BAN	26-Jan-24		01:00
APP	BAN	26-Jan-24	15:00

[Ahmedx · Accepted solution]

pls try this