Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |