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