Static sheet after refresh for change tracking

[Anonymous]

Hi team, hope I can explain this. We are going to use our power bi sheet for quarterly reports. When we refresh the data for each quarter is there a way to see what the previous data said so we can analyse what it looks like now and how to identify the changes to what it looked like then (via lookup or query)? Essentially thinking my q1 sheet will be a table in Power BI then when I refresh, another sheet gets created q2, so we can compare them and see trends etc. Data is being pulled from a data warehouse as dealing will mass amounts of data from multipule sources. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

If I understand correctly, it seems that you are trying to compare the quarterly data before refresh and after refresh. Then you can refer the following links to get it. 

Power Query method:

How to track changes in the table in Power Query - Exceed

DAX method:

Solved: How can I compare values from 2 different sheets i... - Microsoft Fabric Community

Delta =

var currentpart = selectedvalue(Table1[PartNumber])

var table1open = calculate(Sum(Table1[Qty]), Table1[Status]="Open")

var table2open = calculate(sum(Table2[Qty]), Table2[Status]="Open", Table2[PartNum]=currentpart)

return table1open-table2open

---

Best Regards