Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tonyclifton
Helper III
Helper III

Compare data between different import dates

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.

comparisonPowerBI.png

 

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:

ProductIdProductNameImportDate
1A01.01.2021
2B01.01.2021
1A01.02.2021
3C01.02.2021
1A01.03.2021
3C01.03.2021


Thank you.

1 REPLY 1
amitchandak
Super User
Super User

@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...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.