How to store a historical data of a calculated table during every refresh?

[Anonymous]

I have a a calculated table that gets refreshed during every refresh.

Weight = SUMMARIZE(filter(Sprints,Sprints[Delivery Name] in {"Retail Service","ATLAS DG"}),'Sprints'[Delivery Name],Sprints[Delivery Team],Sprints[Component],Sprints[Sprint Name],"Planned",[Planned Weight],"Mid",[Mid Weight],"End",[End Weight],"Total Sprint Score",[Total Sprint Score New])

I refresh my source dataset every week. Right now it just refreshes the calculated table values. I want to store last week's calculated table result set when I am doing this week refresh so that it will help me for my historical analysis. any ideas? thanks

[amitchandak]

@Anonymous , see if 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-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/