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....
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
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.