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
Hi tgfauzan9303,
It looks like the issue happens in Power BI desktop, right?
Would you please clarify the detail steps that you are taking cause the issue? It would be better if you could provide some screenshots. Do mask sensitive information in screenshots before uploading here.
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 YuHi Qiuyun Yu
Thanks for the information.