Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |