How to save a point in time snapshot for comparison at a later date?

[michael95677]

The request is to compare scheduled appointments from the past week and then compare a week later to how many actually kept their appointments. Because the appointments can be cancelled, rescheduled or just have no shows it means the status changes daily so a snapshot would need to be taken. 

I was thinking maybe using Power Automate to run a query and store the data in Excel then pull that data for comparison a week later in Power BI. Any thoughts on the best way to do this would be appreciated. Thank you. 

[amitchandak · Accepted solution]

@michael95677 , I think the DAX append method can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[michael95677]

Thank you. Appreciate the help.