Forum Discussion
Solved
Maintain historical Data
Hello all, I have a transaction system that contains percentage completion and status of Projects. The thing is, when the percentage completion of a project is updated, the previous value is lost an...
You cannot. Power BI is a "read only" system so it doesn't have the ability to store data beyond a refresh.
You will either have to modify the source system (you said not an option), or put in an intermediate process in place to store a previous day snapshot of data, then have Power BI read in the source data and the snapshot, then do the comparison.
