Forum Discussion
Helper ICreate a Variable that holds last refresh date when the refresh date may or may not be today
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
Super UserHi 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
Helper IThank you for that suggestion! It looks like that formula also assumes that the refresh date was the current day, though. Appreciate your feedback!
- FBergamaschi
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
- colettb
Thank you so much, you've saved the day 😀