Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |