Hello,
I have data which has Columns Year,Team,Item,Status,Cost. My requirement is that i have two slicers for the Year column and the user selects start year in one and end year in other. The final results table should show only those Items, which are exclusive to end year and were not part of start year. Also along with the items column,other columns should be displayed in the results table.
See below data for example: TABLE1
| YEAR | TEAM | ITEM | STATUS | VALUE |
| 2020 | A | CAR | sold | 100 |
| 2020 | A | PENCIL | unsold | 90 |
| 2020 | B | BIKE | rejected | 250 |
| 2020 | C | PEN | sold | 100 |
| 2021 | A | CAR | sold | 100 |
| 2021 | B | BOOK | sold | 50 |
| 2021 | C | SCOOTER | unsold | 50 |
| 2022 | B | BOOK | rejected | 300 |
| 2022 | B | LAPTOP | rejected | 200 |
| 2022 | C | TABLE | sold | 100 |
So if slicer 1 is 2020 and slicer 2 is 2021, is hould in the results table see only this.
| 2021 | B | BOOK | sold | 50 |
| 2021 | C | SCOOTER | unsold | 50 |
**The "Car" row is common in both hence should be ommitted.
Note: I have made a table 2 with Distinct values of "Year" from table 1 and using that for slicer 1. But even with all DAX Commands like ALLEXCEPT,DISTINCT, i cant manage to solve this.
