Create a Variable that holds last refresh date when the refresh date may or may not be today

[colettb]

Hello!

I need to create a column that holds the last refresh date of the data.  All the threads and videos I find are assuming that today is the last refresh date when they show the formula to put in the blank query.  What if the data hasn't actually been refreshed in a week or two weeks?  Is it possible to display the actual date the data was last refreshed?

Thanks for any guidance!

[FBergamaschi]

Hi @colettb 

this is the best solution I know so far, based on Power Query

https://radacad.com/showing-current-time-and-latest-refresh-time-at-local-timezones-in-the-power-bi-...

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[colettb]

Thank  you for that suggestion!  It looks like that formula also assumes that the refresh date was the current day, though.  Appreciate your feedback!

[FBergamaschi · Accepted solution]

I thought it did not, I shall recheck then

Meanwhile, here another option

https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Last-Refresh-Date-in-Power-BI/ba-p...

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[colettb]

Thank you so much, you've saved the day 😀