Hi Communtiy,
Recently i was working on a request where the client wanted to see the last week value of my data. As the power bi refreshes daily there is no direct way to preserve all my key kpi value in the model. Like today is 12/8/2025 now even if i create a table with all the measure and the date value. Tomorrow the date wont be static it will change. So everyday the date value value will keep on changing and historical value wont be preserve. unless we capture it on an excel hosted on sharepoint via power automate. Which eventually i did. So shouldnt there be a way to store these value in the Power bi. I know it may consume spaces but there could be a way to maybe transfer those value onto excel automatically and not manually downloading it.
