Forum Discussion
Query Error
Hi tgfauzan9303,
Power Query doesn't have switch function, you can use DAX Switch() function instead.
If you want to create a custom column in Query Editor use Power Query, you can use If... then... else... or use custom function, see: https://www.excelguru.ca/blog/2014/09/03/multi-condition-logic-in-power-query/
Best Regards,
Qiuyun Yu
I add custom column as below
Edit Query -> Add customn column
Hi tgfauzan9303,
Power Query doesn't have switch function, you can use DAX Switch() function instead.
If you want to create a custom column in Query Editor use Power Query, you can use If... then... else... or use custom function, see: https://www.excelguru.ca/blog/2014/09/03/multi-condition-logic-in-power-query/
Best Regards,
Qiuyun Yu
Hi Qiuyun Yu
Thanks for the information.