Forum Discussion

ElvirBotic's avatar
ElvirBotic
Icon for Helper III rankHelper III
3 years ago
Solved

Add 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...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    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's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
3 years ago

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 obtain

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !