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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

October NL Carousel

Fabric Community Update - October 2024

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