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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors