Forum Discussion
AliceW
Power Participant
Power ParticipantConvert a multiple IF formula from DAX to M
Hi folks, I am terrible at M and I really need this formula in the Power Query so that I can then unpivot the table. Could anybody help me, please? 2019-01 = SWITCH('Business'[Line], "Lyme", ...
Hi AliceW ,
See if these blogs help you
https://www.youtube.com/watch?v=ivNtaAl7XNM
https://www.poweredsolutions.co/2019/06/09/logical-operators-and-nested-ifs-in-power-bi-power-query/
https://www.myonlinetraininghub.com/power-query-if-statements
https://exceloffthegrid.com/power-query-if-statements-for-conditional-logic/
https://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/
Regards,
Harsh Nathani