Forum Discussion
Date Time
Hi
I am looking for a DAX which will get me the future date.
Like we have a weekly refresh so once we refresh the report the latest refresh date should show along with NEXT refresh Date
i.e. Refresh date : 07/16/2022 Next Refresh Date: 07/23/2022
Please reffer following.
https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops
using that you can get last refreshed date.
Then use following dax code
DATEADD(DateTime[Refresh Date],7,DAY)
Thank you
2 Replies
Anonymous if you already have the refresh date then to get 7 days ahead you can just add 7 to that date.
Not sure if that is what you meant.Please reffer following.
https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops
using that you can get last refreshed date.
Then use following dax code
DATEADD(DateTime[Refresh Date],7,DAY)
Thank you
