Final answer:
To add a last refresh date in Power BI, create a new measure with the DAX formula Last Refresh = NOW(), which will display the refresh date each time the report is refreshed. This measure can be used in a card visual on your report.
Step-by-step explanation:
To add a last refresh date in Power BI, you can insert a simple measure within your data model to display when the data was last refreshed. Here are the steps you can follow:
- Click on the 'Modeling' tab in Power BI Desktop.
- Create a new measure by selecting 'New Measure' from the ribbon.
- In the formula bar, enter the following DAX formula: Last Refresh = NOW().
- After creating the measure, you can use it in a card visual to display the last refresh date on your Power BI report.
This measure will automatically update each time the report is refreshed, providing users with the most up-to-date timestamp. You can format this measure to show just the date, or the date and time, depending on your requirements.