Forum Discussion

AliceW's avatar
AliceW
Icon for Power Participant rankPower Participant
6 years ago

Convert 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", ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

M is much simpler than DAX in this respect. All it has is and and or. No fancy switch syntax sugar.

Keep in mind that in Power Query your tables are not yet related.  You either need to merge tables, or use custom column generator functions to lookup values in other tables.

 

Best would be to provide sample data for your row data source and business data source.