The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi!
I have two identical tables, the second (Table B) is the copy of the first (Table A) and a third table of distinct values of the two, related to both tables.
I created a slicer for each of the two tables A and B which filters the date.
What I would like to do is check if the record in "ITEM" field, by selecting two different dates on the two tables, is present in both or only in one of the two.
In short, if the record of the "ITEM" field between the two selected periods remains or is no longer present, since one table is the copy of the other.
Thx,
B.
Tables A and B are identical. ITEM1 is native to the table, ITEM2 instead is taken from the Distincts Table. In fact, the Distincts table is a table of distinct values of Table A / B, enriched with the ITEM2 field, then related to both tables. On each of the two tables A and B there is a Slicer on the date. As you can see by filtering the slicers on two different periods, the data in Table A or B may no longer be present or change for the ITEM2 field, ITEM1 is not important. I would like a single table that would show all those records that filtering the two slicers changes from Table A to Table B for the ITEM2 value. So in this case, i would like to show only the first row of Table A, that has disapperead in Table B.
@BeaBF provide some sample data.
User | Count |
---|---|
15 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
24 | |
20 | |
12 | |
9 | |
7 |