Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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'
Solved! Go to Solution.
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)
)
)
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)
)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |