Query Error

[tgfauzan9303]

Hi, goood day all , i creates some new query in power BI, but it show error message "TOken Literal Expected " on AND statement.  Does anyone can provide me a solution for this. SWITCH (wrhwr_eot_overdue[status_generated] = '1' AND (wrhwr_eot_overdue[status_open] ='1' AND (wrhwr_eot_overdue[status_complete]='1' AND (wrhwr_eot_overdue[status_overdue]='1' AND (wrhwr_eot_overdue[status_eot]='1' AND )))))

[v-qiuyu-msft]

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

[tgfauzan9303]

I add custom column as below

Edit Query -> Add customn column 

[v-qiuyu-msft · Accepted solution]

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

[tgfauzan9303]

Hi Qiuyun Yu

Thanks for the information.