Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

compare (refreshed) sales data vs last data set



My PBI dashboard is scheduled to refresh ~8 hours with data from SFDC. I'd like to display the changes in various (pipeline/forecast/won) metrics versus the previous day.


Example: Tuesday's 8AM dashboard compares against Monday's 8AM, Tuesday 5PM compares against Monday 5PM, or Monday 8AM- since deals aren't moving that fast). 


Is this possible? I'm being told that I'll need to manually save yesterday's data because the scheduled refresh wipes the data and replaces with new data. Is there a way to automatically "lock" data from a previous refresh?


thanks! -TF

Super User IV
Super User IV

Re: compare (refreshed) sales data vs last data set

What you are being told is correct. No real way around it other than perhaps some fancy, tricky M code maybe?


@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors