Forum Discussion
Create a Variable that holds last refresh date when the refresh date may or may not be today
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!
I thought it did not, I shall recheck then
Meanwhile, here another option
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
4 Replies
Hi colettb
this is the best solution I know so far, based on Power Query
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
Thank you for that suggestion! It looks like that formula also assumes that the refresh date was the current day, though. Appreciate your feedback!
I thought it did not, I shall recheck then
Meanwhile, here another option
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
