Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |