The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
119 | |
86 | |
75 | |
55 | |
44 |
User | Count |
---|---|
136 | |
128 | |
78 | |
64 | |
63 |