topic Re: DAX case if else from separate columns in DAX Commands and Tips

DAX case if else from separate columns

Bizo — Thu, 21 Jul 2022 00:13:18 GMT

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!

Re: DAX case if else from separate columns

SpartaBI — Thu, 21 Jul 2022 14:58:29 GMT

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

Re: DAX case if else from separate columns

Bizo — Thu, 21 Jul 2022 15:28:06 GMT

Thanks!

Re: DAX case if else from separate columns

SpartaBI — Thu, 21 Jul 2022 15:35:02 GMT

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 🙂