Forum Discussion
last time refresh
- 10 years ago
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 :-)
- 10 years ago
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
Yes, that's what I'm expecting in the Dashboard view, but there I see nothing. The screenshot from the "Last 24 hours" is the one from the Dashboard view. When clicking on the box in the Dashboard view, I see nothing, just the faint outline of the tile. I will say the Dashboard and the Report have two different names. I've seen in other areas there may be issues if things are named differently, could this be the case here though?
thanks.