cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jig_S
Frequent Visitor

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

 

2 REPLIES 2
Super User I
Super User I

Re: Calculate Incremental Changes between Dashboard Refresh

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.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Super User I
Super User I

Re: Calculate Incremental Changes between Dashboard Refresh

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

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors