Forum Discussion

Helper V

10 years ago

Solved

last time refresh

Hi, Is it possible to add to the report/dashboard the date and time of the last refresh? Many thanks. Nir

nirrobi
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 :-)
idanco
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

Advocate II

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

Frequent Visitor

10 years ago

This is not possible in either my Desktop or Service . Am I missing something?

Thanks!