DAX case if else from separate columns

[Bizo]

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",

    'vw_CAP_PreAudit_5Yrs_PN_BEF'[Work Type Code],"HNA","Vegetation",

    "Non-Pole",

    )

Basically if CONTAINSSTRING('vw_CAP_PreAudit_5Yrs_PN_BEF'[MAT], "07"),"Pole", or  'vw_CAP_PreAudit_5Yrs_PN_BEF'[Work Type Code],"HNA","Vegetation", else it = " Non-Pole".

Any suggestions?  Thanks in advance!

[Bizo]

Thanks!

[SpartaBI]

@Bizo my pleasure 🙂
Will appreicate your Kudos 🙂
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. 
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂

[SpartaBI · Accepted solution]

@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