Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I would like to filter items based on another table. I will try to explain the issue in an simple example.
Table A:
A |
| B |
| C |
| D |
| E |
Table B:
| B |
| D |
| E |
Based on this example, i would like Table A to only show rows A and C, that means the rows, that do not appear in Table B. Can someone help me do that?
Thanx in advance!
Solved! Go to Solution.
EXCEPT('Table A','Table B')
| User | Count |
|---|---|
| 55 | |
| 42 | |
| 28 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 74 | |
| 63 | |
| 40 | |
| 23 | |
| 22 |