Forum Discussion

Jsonify's avatar
Jsonify
Frequent Visitor
5 years ago
Solved

Need help implementing WHERE clause in Power Query

In my SELECT statement, I am having trouble implementing the WHERE clause since it is using the LOWER command. I'm also struggling to get the ('(Invalid)', ('Not Specified')') parts of the statement....
amitchandak's avatar
amitchandak
Super User
5 years ago

Jsonify , Tables should be joined

 

you need to have two filter clauses

 

filter(T_TESTCASE,
NOT (T_TESTCASE[TESTCASEFOLDER_NAME1] IN ('(Invalid)', '(Not Specified)')
|| SEARCH("archive",T_TESTCASE.TESTCASEFOLDER_NAME1,1,0) >0
|| SEARCH("recycle%bin",T_TESTCASE.TESTCASEFOLDER_NAME1,1,0) >0
|| SEARCH("temp"T_TESTCASE.TESTCASEFOLDER_NAME1,1,0) >0

 

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

https://www.sqlshack.com/implementing-star-schemas-in-power-bi-desktop/
|| SEARCH("delete"T_TESTCASE.TESTCASEFOLDER_NAME1,1,0) >0
&& isblank(T_TESTCASE[DELETED_DATETIME]))


, filter(T_PROJECT, isblank(T_PROJECT[DELETED_DATETIME]) && NOT(T_PROJECT.DOMAIN_NAME IN {"(Invalid)", "(Not Specified)"}))