Forum Discussion
Solved
if statement
| Model Name | OD DATE | OD1 | OD2 DATE | OD2 | OD3 DATE | OD3 |
| A | 1/3/2021 | YES | 4/4/2021 | YES | - | |
| B | 1/1/2021 | YES | 1/6/2022 | NO | 1/3/2021 | YES |
| C | 1/3/2021 | YES | 4/4/2021 | YES | 2/10/2022 | YES |
| D | 1/5/2021 | - | - | 1/1/2021 | NO |
I have created calcuated columns of OD1 OD2 OD3
I would like to show both in measure and column ways:
if we have the OD Dates and these ODs are Yes then "OK" othervise "Drop" the entire model
SelflearningBi So maybe a Complex Selector like:
Selector Measure = IF( [OD DATE] <> BLANK && [OD1] = "YES" && [OD2 DATE] <> BLANK() && [OD2] = "YES" && [OD3 DATE] <> BLANK() && {OD3] = "YES", 1, 0 )
1 Reply
SelflearningBi So maybe a Complex Selector like:
Selector Measure = IF( [OD DATE] <> BLANK && [OD1] = "YES" && [OD2 DATE] <> BLANK() && [OD2] = "YES" && [OD3 DATE] <> BLANK() && {OD3] = "YES", 1, 0 )