March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have an SQL Table that keeps a snapshot of the data that was used in a report from the previous week. I have imported this table into the Power BI Desktop report that has the current weeks report.
I'd like to be able to create a calculated table that contains rows for any records where the values in the snapshot from last week are different this week.
This is an "Opportunities" list and by different, I mean the following could have changed:
So essentially, the steps I need to take are:
Any thoughts on how I might address this would be greatly appreciated.
Many thanks,
Kind regards,
D.
Hi @dparkinson,
Have you tried the solutions provided above? Do they work in your scenario? If the solution works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Hi,
Power Query has various types of joins which should address your first two convers atleast. Please try them.
Hi,
May be
Table = UNION ( CALCULATETABLE ( TableCurrent, EXCEPT ( TableCurrent, TableSnapshot ) ), CALCULATETABLE ( TableSnapshot, EXCEPT ( TableSnapshot, TableCurrent ) ) )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |