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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
AlGrant
Frequent Visitor

Help with identifying items that have been added or removed from a table between dates

Hello,

 

I have a large historical data set, in one table, made up of weekly snap shots of server names and associated applications that sit on those servers. There are over 6K records many are duplicate as apps share servers, and there is a line item for each apps sharing the server in each date snap. I need to be able to identify two historical dates and show details from apps and servers that have been added or removed between those dates.

 

Can anyone help with the expressions needed to create two new tables that can filter based on two dates; one table for items added and one for items removed between two dates?

 

Thank you

1 REPLY 1
AlGrant
Frequent Visitor

Hi @jdbuchanan71 and @grantsamborn any chance either of you can help on this one?

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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