Updating a text box with database update date

[redalert787]

Hello, 

I have a report with several manual excel database. One of the databases, I update 2 times a week and the other I update every tuesday. 

My report has several pages that associate the different reports. 

I would like to put a text box on all the pages that I can update just once (either through a DAX code or something else) that just says when the data on a certain page was updated. 

Can anyone help me with this? 

Thanks, 

[JoeBarry]

Hi @redalert787 

If there is a column in the excel that has the update date, you can utilise this.

Create a measure 

Last Data Update = MAX('Table'[UpdateDate])

Add this measure to a card

Thanks

Joe

If this post helps, then please Accept it as the solution

[redalert787]

Hello, 

I created a table in excel with a column for showing when each of my databases were updated. I created a DAX measure based on the one that noted above. Then I put the measure into a card but it is showing blank. Would you be able to help to show me where I am going wrong @JoeBarry 

Excel table: 

DAX measure: 

Card showing blank for measure: 

Thanks, 

[JoeBarry · Accepted solution]

Hi @redalert787 

Put an actual date in the excel, no text. When you import the excel, make sure that it is in date format. You can add title for the text you want to add.

Joe