[UNSOLVED] Track changes between multiple tables

Hi FU ,

//I want to be able to select 2 reports/dates

Using a slicer to switch tables seems difficult to do.
My idea is to group the tables by table's name(Week1..Week2) and then append the query as one table. Then create two unconnected Dim table's name tables for the two slicers. Then new a measure like:

Measure = 
VAR _slicer1 = SELECTEDVALUE('Table 2'[Name])
VAR _slicer2 = SELECTEDVALUE('Table 3'[Name])
VAR _pjid = SELECTEDVALUE('Table'[Project ID])
VAR _forecast1 = CALCULATE(MAX('Table'[Forecast]),'Table'[Name]=_slicer1)
VAR _forecast2 = CALCULATE(MAX('Table'[Forecast]),'Table'[Name]=_slicer2)
VAR _status1 = CALCULATE(MAX('Table'[Status]),'Table'[Name]=_slicer1)
VAR _status2 = CALCULATE(MAX('Table'[Status]),'Table'[Name]=_slicer2)
RETURN
IF(_forecast1<>_forecast2||_status1<>_status2,1)

result:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum