date stamps

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Date stamps

Date stamps

resolvedResolved · Medium Priority · Version 365

Date stamps

How is it possible to have a date stamp for when the latest data was in the report?

RE: Date stamps

Hi Tom,

Thank you for your question to the forum.

To create a 'date stamp' to show the last refresh date, you will need to write a query using Power Query M. This involves creating a Blank Query from Get Data in Power BI Desktop and writing the script in Power Query. Once you have closed and applied, the query will appear on the right with all other tables. You can then use this field to drop it into a Card visual to display the Date Stamp. For more details on the actual script and the whole process, click on the video link below:

https://www.google.com/search?q=power +bi+add+date+stamp&rlz=1C1GCEB_enGB950GB950&oq=power+bi+date+stamp+&gs_lcrp=EgZjaHJvbWUqCAgEEAAYFhgeMgoIABBFGBYYHhg5MggIARAAGBYYHjIICAIQABgWGB4yCAgDEAAYFhgeMggIBBAAGBYYHjIICAUQABgWGB4yCAgGEAAYFhgeMggIBxAAGBYYHjIICAgQABgWGB4yDQgJEAAYhgMYgAQYigXSAQoxOTYwNmowajE1qAIAsAIA&sourceid=chrome&ie=UTF-8#fpstate=ive&vld=cid:c6b1c89b,vid:vM9D6xYo0KM,st:0

Now whenever you click the refresh button to update source changes, the Date stamp will update

The video also takes you through some DAX in order to refine the wording and formatting of the Date Stamp. You could just skip this part and simply create a text box entitled 'Last Refreshed on' and position this above the Date stamp.

I hope this helps and please let me know if this has worked

Kind regards
Martin Sutherland
(IT Trainer)

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

 

Training courses

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Power BI tip:

General Shortcuts

Ctrl + S: Save the report or dashboard.
Ctrl + Z: Undo the last action.
Ctrl + Y: Redo the last undone action.
Ctrl + C: Copy selected items.
Ctrl + X: Cut selected items.
Ctrl + V: Paste copied or cut items.
Ctrl + A: Select all items.
Ctrl + N: Create a new report or dashboard.

View all Power BI hints and tips


Server loaded in 0.09 secs.