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...
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