Forum Discussion
Solved
DAX from Excel
In excel, I can add years to a date to determine at futre date, for example, what is the date 27 years from 09/11/2011 this gives me 9/11/2038, and I can apply this simple =DATE across a ...
You can use the dateadd function which would be something like
Date + 27 days = dateadd(Table[Date],27, day)Hi Lex23,
You may be looking for EDATE. The unit of measure is months though so in your example, you would use 27*12.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Wilson_
Memorable Member
Memorable MemberHi Lex23,
You may be looking for EDATE. The unit of measure is months though so in your example, you would use 27*12.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)