Forum Discussion
Anonymous
2 years agoNot applicable
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...
- 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.
Greg_Deckler
2 years agoCommunity Champion
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.