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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors