Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
76 | |
66 | |
60 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |