Forum Discussion
a_yang
4 years agoFrequent Visitor
Display Last Refresh Date with New Data
Hello, How can I display the last refresh data when there is new data? I found this formula but it gives me the date everytime the dashboard refreshes, I have it automatically refreshing a couple...
- 4 years ago
No. You have two options:
- Last time it was refreshed - blog here Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics
- Lastest date in your data - so a CALCULATE(MAX(Table[DateValue]), REMOVEFILTERS()) would show this if you have a date column in your fact data.
But when Power BI Refreshes, it doesn't check to see if anything changed, it assumes it all changes on refresh.
edhans
4 years agoCommunity Champion
No. You have two options:
- Last time it was refreshed - blog here Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics
- Lastest date in your data - so a CALCULATE(MAX(Table[DateValue]), REMOVEFILTERS()) would show this if you have a date column in your fact data.
But when Power BI Refreshes, it doesn't check to see if anything changed, it assumes it all changes on refresh.
a_yang
4 years agoFrequent Visitor
Thank you!