Forum Discussion

SelflearningBi's avatar
SelflearningBi
Helper III
3 years ago
Solved

IF measure

Model Name OD1 OD2 OD3 OD4 A YES NO NO NO C NO YES NO NO B YES YES NO NO C NO NO NO NO I would like to have a new column meet this condition:    If OD1 is Y...
Need Help
Show and Tell
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, SelflearningBi 

    Please try formula like:

    Column =
SWITCH (
    TRUE (),
    'Table'[OD1] = "Yes", "keep OD1",
    'Table'[OD2] = "Yes", "suguest to use OD1",
    'Table'[OD3] = "Yes", "suguest to use OD2",
    'Table'[OD4] = "Yes", "suguest to use OD3",
    "Drop All"
)

    Best Regards,
    Community Support Team _ Eason

SelflearningBi's avatar
SelflearningBi
Helper III
3 years ago

amitchandak 
Hi thank you for helping, I was wondeirng is there a function we could say
if
OD1 is meet than keep OD1
OD2 is meet but OD1 is not meet then we suuguest to use OD1
OD3 is meet but OD2 is not then we sugguest to use OD2

Like I would like to suuguest to use previous one in all conditions

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi, SelflearningBi 

Please try formula like:

Column =
SWITCH (
    TRUE (),
    'Table'[OD1] = "Yes", "keep OD1",
    'Table'[OD2] = "Yes", "suguest to use OD1",
    'Table'[OD3] = "Yes", "suguest to use OD2",
    'Table'[OD4] = "Yes", "suguest to use OD3",
    "Drop All"
)

Best Regards,
Community Support Team _ Eason