Forum Discussion
nirrobi
10 years agoHelper V
last time refresh
Hi, Is it possible to add to the report/dashboard the date and time of the last refresh? Many thanks. Nir
- 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
wynhopkins
9 years agoMost Valuable Professional
vkdubw
9 years agoRegular Visitor
Yep, that's exactly where I'm at. I'm going to give it a few days of rest then pick it up again. Thanks for the confirmation that I'm looking in the correct area.