Forum Discussion

Regular Visitor

6 years ago

Solved

Query Error

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

Need Help

v-qiuyu-msft
6 years ago
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

4 Replies

v-qiuyu-msft
Community Support
6 years ago
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
  Regular Visitor
  6 years ago
  I add custom column as below
  
  Edit Query -> Add customn column
  - v-qiuyu-msft
    Community Support
    6 years ago
    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

Forum Discussion

Query Error

4 Replies

Related content

Query Errors

kusto error- partial query failure

Query Resources Exceeded Error

Error in Mirrored google Big query

Query resources Exceeded error