The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Hi @jdbuchanan71 and @grantsamborn any chance either of you can help on this one?