Forum Discussion
Helper IIIAdd Years to Date
Hello, I have a table with two columns. Column A is a Install Date and Column B is the life expectancy of that asset. Life expectancy is always X amount of years. I want to take the date an asset was installed and calculate the replacement date using those two columns.
I have tried using the DATEADD expression, but that only allowed me to do a fixed amount of years. SInce each asset has its own life expectancy I had no success simply adding to that install date in a calculated column. Any help or tips would be appreciated.
Example:
| Install Date | Life Expectancy (Years) | Replacement Date |
| 10/11/2022 | 5 | 10/11/2027 |
| 8/24/2021 | 15 | 08/24/2036 |
| 09/20/2018 | 7 | 09/20/2025 |
Hi, ElvirBotic ;
You could also try .
Replacement Date2 = EDATE([Install Date],[Life Expectancy (Years)]*12)The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-yalanwu-msftCommunity Support
Hi, ElvirBotic ;
You could also try .
Replacement Date2 = EDATE([Install Date],[Life Expectancy (Years)]*12)The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- serpiva64
Solution Sage
Hi,
you can try this calculated column
Replacement Date = Date(YEAR('Table'[Install Date])+'Table'[Life Expectancy (Years)],MONTH('Table'[Install Date]),day('Table'[Install Date]))and obtainIf this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
