Calculate Incremental Changes between Dashboard Refresh

[Jig_S]

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 refresh. Would like to use DAX to accomplish this and not the database.

This would help us tremendously to answer a question from our Clientele to identify changes to certain monitored metrics for consistancy and take decisions accordingly. Really appreciate any help I can get to resolve the query.

Best Regards,

[CheenuSing]

Hi @Jig_S

One thought that comes to mind is this.

1. In your fact table add a column called RefreshDate that will point to the actual date of refresh.

2. Create a copy of the metric measures and in the new measures filter fact table upto the date of refresh which is lower than the current date of refresh.

3. display the current and lastrefreshed metrics.

If this works for you, please accept this as a solution and also give KUDOS.

Cheers

CheenuSing

[KHorseman]

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.