Forum Discussion
nirrobi
Helper V
Helper Vlast time refresh
Hi, Is it possible to add to the report/dashboard the date and time of the last refresh? Many thanks. Nir
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
Hi all,
Best way to actually do this is to pull in this website using the web conector https://www.timeanddate.com/worldclock/uk/london
***edit*** go here https://www.timeanddate.com/worldclock/uk
Use a card to display the cities time you would like :)
far easier than all this coding!