Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Switch with multiple conditions

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 ...
  • Greg_Deckler's avatar
    6 years ago

    Use SWITCH(TRUE()...) like:

     

    SWITCH(TRUE(),

      <condition1> && <condition2>,<result1>,

      <condition3> && <condition4>,<result2>

      <default result>

    )