Forum Discussion
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_Electricalsystem_Percentage] && vw_fct_ikea_blue_rdr[_1_2_Smokingandopenflame_Percentage] && vw_fct_ikea_blue_rdr[_1_3_Flammableliquidgasanddust_Percentage] && vw_fct_ikea_blue_rdr[_1_4_Arsonandhousekeeping_Percentage] && vw_fct_ikea_blue_rdr[_1_6_Batterycharging_Percentage] = "Fire Prevention","")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.
1 Reply
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.