Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have following table:
id date
1a 01.01.19
1a 02.01.19
2a 03.01.19
3a 04.01.19
4a 02.02.19
4a 03.02.19
2a 04.02.19
I'm trying to calculate amount of distinct ID's in previous period which are not appearing in selected period.
So selecting Feb'2019 should return - 2 ("1a" and "3a" are counted since they are not appearing in the current period, but appeared in previous period (so in Jan))
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |