Forum Discussion

nirrobi's avatar
nirrobi
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
Need Help
  • idanco's avatar
    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

     

     

vbaker's avatar
vbaker
Helper I
8 years ago

How are you automatically accounting for Daylight Saving Time?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

We have removed the time indication and are just showing the date as the lazy solution, or where it doesn't really matter if the time is out by an hour not bothering to fix it.

 

To deal with this across all the dashboards in the future we will

1) Only publish the date where time doesn't matter.

2) Adopt the solution suggested by Anonymous and using a SQL database that we have access to.

3) Another alternative is to scrape the time from a webpage that specifies the time in Summer time. Although I don't like the idea of introducing a dependency on an external website in out dashboards.