Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello community,
I have a product history table which once a month imports active products. I would like to compare based on the ImportDate in below screenshot which products have been set to inactive (they are not in the list anymore for that date) or have been added to the list.
I want to select a start and comparison date to see the difference between the two.
I have not been able to figure out a formula to make this happen or how to present the data (one list or two?). Can you help me?
Table:
ProductId | ProductName | ImportDate |
1 | A | 01.01.2021 |
2 | B | 01.01.2021 |
1 | A | 01.02.2021 |
3 | C | 01.02.2021 |
1 | A | 01.03.2021 |
3 | C | 01.03.2021 |
Thank you.
@tonyclifton , Either you need two slicers or day on day comparison. In both cases, this period vs last period will give new, repeat, lost, as this blog
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |