Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
AUDISU
Resolver III
Resolver III

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

View solution in original post

2 REPLIES 2
AUDISU
Resolver III
Resolver III

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
Community Champion
Community Champion

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

SpartaBI_0-1657989522468.png

 




2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors