Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to 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
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
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,
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