Forum Discussion

redalert787's avatar
redalert787
Helper II
2 years ago
Solved

Updating a text box with database update date

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...
Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    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

JoeBarry's avatar
JoeBarry
Solution Sage
2 years ago

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's avatar
redalert787
Helper II
2 years ago

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's avatar
    JoeBarry
    Solution Sage
    2 years ago

    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