Forum Discussion

dparkinson's avatar
dparkinson
Advocate I
8 years ago

Create a Calculated Table of Differences between Tables

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....
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi,

May be

Table =
UNION (
    CALCULATETABLE ( TableCurrent, EXCEPT ( TableCurrent, TableSnapshot ) ),
    CALCULATETABLE ( TableSnapshot, EXCEPT ( TableSnapshot, TableCurrent ) )
)