How to capture change in data every 24 hrs

[Anonymous]

Hi All,

I have a power bi report, it is a SQL Query and gets data from few tables and performs calculations. I published and scheduled for refresh at 8AM, the fields are like below. What I am looking for is, the next day when the report runs, I should see an additional column showing the difference between the runs, like 24hr difference.Like the seconds dataset,is this possible?

Thanks

startdate	startyear	marketingdeadline	listingdeadline	notsubmittedlots	submittedllots
7/25/2023	7/15/1905	6/21/2023	6/17/2023	0	1
7/17/2023	7/15/1905	6/13/2023	6/9/2023	16	4
6/27/2023	7/15/1905	5/24/2023	5/20/2023	0	27

startdate	startyear	marketingdeadline	listingdeadline	notsubmittedlots	submittedllots	diff
7/25/2023	7/15/1905	6/21/2023	6/17/2023	0	1	20
7/17/2023	7/15/1905	6/13/2023	6/9/2023	16	4	37
6/27/2023	7/15/1905	5/24/2023	5/20/2023	0	27	54

[lbendlin]

Power BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, yes, there is the self referencing option but that is rather advanced.

[Anonymous]

@lbendlin thanks. Is there a way I can download it as an excel and use that as a refernce for the next day run?

[lbendlin]

No need for Excel.  You can self-reference to the dataset during the Power Query ETL. Fair warning - this is rather advanced and not at all robust.