Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I have a new column definition [BedCount] written in DAX using several nested IF statements. I wanted to implement SWITCH to make things cleaner, but I couldn't wrap my head around how I would implement an AND in SWITCH. Any guideance on how to re-write this with SWITCH would be appreciated. I'd like to figure out how to do this as a Measure too, but was having trouble wrapping my head around the appropriate context. Having it added as a column "works" so the Measure piece is more about just getting better at Filter & Row context.
For more context, this column is currently added to the table 'prog_ProposeProg'. Basic star schema with the other two referenced tables having a direct relationship to 'prog_ProposeProgram'.
VAR SubCategory = RELATED(prog_CatSub[Name])
VAR Category = RELATED(prog_Categories[Name])
RETURN
IF(
AND(
CONTAINSSTRING(SubCategory, "Acute"),
CONTAINSSTRING(Category, "Inpatient")
),
prog_ProposeProgram[Target Area] / [Acute Inpatient],
IF(
AND(
CONTAINSSTRING(SubCategory, "Critical"),
CONTAINSSTRING(Category, "Inpatient")
),
prog_ProposeProgram[Target Area] / [Critical Bed],
IF(
AND(
CONTAINSSTRING(SubCategory, "Rehab"),
CONTAINSSTRING(Category, "Inpatient")
),
prog_ProposeProgram[Target Area] / [Rehab Bed],
BLANK()
)
)
)
Solved! Go to Solution.
Use SWITCH(TRUE()...) like:
SWITCH(TRUE(),
<condition1> && <condition2>,<result1>,
<condition3> && <condition4>,<result2>
<default result>
)
Use SWITCH(TRUE()...) like:
SWITCH(TRUE(),
<condition1> && <condition2>,<result1>,
<condition3> && <condition4>,<result2>
<default result>
)
duh! Thanks!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
38 | |
21 | |
18 | |
15 |
User | Count |
---|---|
124 | |
39 | |
28 | |
24 | |
23 |