cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JeanBean Frequent Visitor
Frequent Visitor

Multi WHERE Clause: (OR) AND

Hi,

 

This a way to apply an OR in the filter conditions? Or adding an embedded where clause?  The tool already applies ANDs between filters but not ORs

 

EX: (I figured out how to union the two tables, but how do I add the where clauses to the individual data sets?)

SELECT * 

FROM [Table A]

WHERE (region in ('America', 'Europe' OR team = 'testing')

              AND date > '2017-01-01'

 

UNION 

 

SELECT * 

FROM [Table B]

WHERE (region in ('AM', 'EU' OR team = 'TEST')

              AND date > '2017-01-01'

1 ACCEPTED SOLUTION

Accepted Solutions
JeanBean Frequent Visitor
Frequent Visitor

Re: Multi WHERE Clause: (OR) AND

Ok, I think I figured it out. I have to use a combination of UNION, FILTER, SEACH, ||

 

I used the || as a logical OR, and applied the final AND on the Report Filter section

Merge_Table = UNION (FILTER ('Table A'

                                                  SEARCH("America",Table A[region], 1, 0) ||

                                                  SEARCH("Europe",Table A[region], 1, 0) ||

                                                  SEARCH("testing",Table A[team], 1, 0)

                                                  ) ,

                                       FILTER ('Table B'

                                                  SEARCH("AM",Table A[region], 1, 0) ||

                                                  SEARCH("EU",Table A[region], 1, 0) ||

                                                  SEARCH("TEST",Table A[team], 1, 0)

                                                  ) 

                                         )

 

1 REPLY 1
JeanBean Frequent Visitor
Frequent Visitor

Re: Multi WHERE Clause: (OR) AND

Ok, I think I figured it out. I have to use a combination of UNION, FILTER, SEACH, ||

 

I used the || as a logical OR, and applied the final AND on the Report Filter section

Merge_Table = UNION (FILTER ('Table A'

                                                  SEARCH("America",Table A[region], 1, 0) ||

                                                  SEARCH("Europe",Table A[region], 1, 0) ||

                                                  SEARCH("testing",Table A[team], 1, 0)

                                                  ) ,

                                       FILTER ('Table B'

                                                  SEARCH("AM",Table A[region], 1, 0) ||

                                                  SEARCH("EU",Table A[region], 1, 0) ||

                                                  SEARCH("TEST",Table A[team], 1, 0)

                                                  ) 

                                         )