Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Power BI community
I want to add 2 years to today in DAX.
My Dax is like this
Two years in the future = Today() + 730
My problem is that this DAX doesn't respect leap years.
Is there someway to change the DAX so it adds years instead of days?
All help is appriciated
Solved! Go to Solution.
Use the DATEADD function:
New Date = DATEADD('Table Name'[Old Date], +2 , year)
see also:
I did this
Use the DATEADD function:
New Date = DATEADD('Table Name'[Old Date], +2 , year)
see also:
Thanks for the solution.
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |