add a refresh date

Add a refresh date to your report

Final users need to know when the report has been refreshed for the last time. Here is my way to do it. I simply add a refresh date in a visual.

How to add a refresh date to your report

Create a table using ‘Home/Enter data’ menu and name it as you want. Add a column named ‘Index’. Add one line of data typing zero in ‘Index’ column.

add a refresh date

Open Power Query and open the query of this table then create a column :

ThisStep = Table.AddColumn(PreviousStep, "Last refresh date", each DateTime.LocalNow(), type datetime)

Use this column in a card visual. The date & time will be updated when you refresh your report. It will not be updated when you simply open the report.

One Comment

Leave a Reply

Your email address will not be published.