topic Re: Query Error in Developer

Query Error

tgfauzan9303 — Thu, 07 May 2020 04:39:38 GMT

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 )))))

Re: Query Error

v-qiuyu-msft — Thu, 07 May 2020 05:23:48 GMT

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

Re: Query Error

tgfauzan9303 — Fri, 08 May 2020 04:44:30 GMT

I add custom column as below

Edit Query -> Add customn column

Re: Query Error

v-qiuyu-msft — Wed, 13 May 2020 08:59:37 GMT

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

Re: Query Error

tgfauzan9303 — Thu, 14 May 2020 01:42:18 GMT

Hi Qiuyun Yu

Thanks for the information.