Multiple IF Function in Power BI - Calculated Column

[Anonymous]

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","")

[Greg_Deckler · Accepted solution]

@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.