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

     

     

pade's avatar
pade
Advocate III
8 years ago

This has been explained before in this thread, but I try to do it more precis

 

First create a DummyTable using the following DAX-code:

DummyTable = DATATABLE(
    "Dummy Column"; BOOLEAN; {{true()}}
)

 

Then create a new calculated column in the DummyTable using the following DAX Code:

Last Data Refresh = NOW()

You might also want to add some text, and that could be done using a measure:

Refresh Time Text = 
"Data Last Refreshed: " & 
FORMAT(
  MAX('DummyTable'[Last Data Refresh]); 
  "yyyy-MM-dd dddd hh:mm:ss"
)

 

You can use any table in you dataset and create a new column, but as only one row is needed (and you might need this dummy table for other things), I would create a DummyTable of one row. You can't (at least I don't know a way) use the now() function within the DATATABLE function, so that needs to be done separately as I describe above