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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.