Forum Discussion
last time refresh
Hi,
Maybe this will solution will help,
http://www.powerpivotpro.com/2010/11/add-a-last-refreshed-date-readout/
I will try tommorow and update :-)
Hi nir,
You can add a calculated column (Last Refresh Column) in the model with the formula =NOW()
And measure Last Refresh Date :=MAX(Table[Last Refresh Column])
Since calculated columns are calculated only on model refresh - it will make sure the calc is right
o show last refreshed on a dashboard click on the 3 dots on the top right OPEN MENU click on the pencil icon TILE DETAILS then click FUNCTIONALITY Display last refresh time This will be good enough for most people. The problem with the new measure solution is that once you open the desktop app it will immediately show you that time as the last refresh time, even if you havent actually refreshed it from the actual data source.
Hi forzajoensy the main problem with the tile details is that is shows when the visual display in the tile was last refreshed not the data itself. So you could have the user thinking that the underlying data was refreshed 10 minutes ago when it hadn't actually changed for 3 months.