Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Trying to use switch using conditions from separate columns but it's not working:
Solved! Go to 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",
)
Thanks!
@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 🙂
@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",
)
User | Count |
---|---|
57 | |
33 | |
18 | |
18 | |
15 |
User | Count |
---|---|
94 | |
85 | |
37 | |
22 | |
20 |