Forum Discussion
gauravnarchal
2 years agoPost Prodigy
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 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 |
pls try this
1 Reply
- AhmedxSuper User