Creating a last-refreshed timestamp

This recipe demonstrates how to create a last-refreshed timestamp for your reports.

Getting ready

Open Power BI Desktop and you are all set!

How to do it...

To implement this recipe, do the following:

1. Use an Enter Data query to create a table called R11_Table with the following information:

2. Create a column in the R11_Table table using the following formula:

Last Refreshed = UTCNOW() + 'R11_Table'[UTC Offset] / 24

3. Create a Card visualization and place the Last Refreshed column into the Fields field for this visualization...