Compare data between different import dates

[tonyclifton]

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.

[amitchandak]

@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

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...