Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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 ) ) )
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |