Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Multiple IF Function in Power BI - Calculated Column

Hi Expert   Not sure if the is the best method to use for multiple IF conidtions for a calculated column - or a Switch Function works best   New Mappng = IF(vw_fct_ikea_blue_rdr[_1_1_Electricals...
  • Greg_Deckler's avatar
    2 years ago

    Anonymous Well, in that specific case, that's just a single IF statement it really doesn't matter. But, in general, use SWITCH( TRUE(), ... ) to replace multiple, nested IF statements, it's just so much cleaner and more readable.