Forum Discussion
Calculate Incremental Changes between Dashboard Refresh
We have our app designed on PowerBI embedded; the dashboards are refreshed every week. Is there a way we can calculate the changes in the metrics, say sum of items before and after the dashboard refr...
It depends on what you're measuring. If the changes come from new records being created in the database, you should be able to write measures that track things by when those records were created. It wouldn't be based on when the dashboard refreshed but it would show the changes over time. I don't think there is any way to track changes since a previous refresh without some intermediate system that saves a snapshot of each refresh's contents. When data is refreshed in Power BI, the old data is not retained. So there is no previous refresh to compare changes against.