Forum Discussion

Bizo's avatar
Bizo
Frequent Visitor
4 years ago
Solved

DAX case if else from separate columns

Hi, Trying to use switch using conditions from separate columns but it's not working:   Category = SWITCH (     TRUE(),     (CONTAINSSTRING('vw_CAP_PreAudit_5Yrs_PN_BEF'[MAT], "07"),"Pole",   ...
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Bizo you mean like this?

     

    Category = 
SWITCH (
    TRUE(),
    CONTAINSSTRING('vw_CAP_PreAudit_5Yrs_PN_BEF'[MAT], "07"),"Pole",
    CONTAINSSTRING('vw_CAP_PreAudit_5Yrs_PN_BEF'[Work Type Code],"HNA"),"Vegetation",
    "Non-Pole",
    )

     





          

    Showcase Report – Contoso By SpartaBI

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Bizo you mean like this?

 

Category = 
SWITCH (
    TRUE(),
    CONTAINSSTRING('vw_CAP_PreAudit_5Yrs_PN_BEF'[MAT], "07"),"Pole",
    CONTAINSSTRING('vw_CAP_PreAudit_5Yrs_PN_BEF'[Work Type Code],"HNA"),"Vegetation",
    "Non-Pole",
    )

 





      

Showcase Report – Contoso By SpartaBI