Forum Discussion

markefrody's avatar
markefrody
Icon for Post Patron rankPost Patron
4 years ago
Solved

DAX For Multiple IF Statements and Conditions

Hi, I am using this sample table: I would like to set-up a DAX wherein: If Check 1 = "Export" show "Export",  If Check 1 = "Domestic show "Domestic", If Check 1 = "Others", go to Check 2...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

    Result CC =
SWITCH (
    TRUE (),
    Data[Check1] = "Export", "Export",
    Data[Check1] = "Domestic", "Domestic",
    Data[Check2] = "Yes", "Import",
    Data[Check3] = "Yes", "Import",
    Data[Check3] = "No", "Unclassified"
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

Result CC =
SWITCH (
    TRUE (),
    Data[Check1] = "Export", "Export",
    Data[Check1] = "Domestic", "Domestic",
    Data[Check2] = "Yes", "Import",
    Data[Check3] = "Yes", "Import",
    Data[Check3] = "No", "Unclassified"
)
  • markefrody's avatar
    markefrody
    Icon for Post Patron rankPost Patron
    4 years ago

    Hi Jihwan_Kim. Thank you. Works perfectly!