Date Time

[Anonymous]

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

[AUDISU · Accepted solution]

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

[SpartaBI]

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

      

Showcase Report – Contoso By SpartaBI