Somebodys age in the future?

[Anonymous]

Hi! I need some help how to calculate from person’s date of birth when he/she will be for example 60, I need the date or month and year.

[mahoneypat · Accepted solution]

Is this a duplicate post?  Here is what I proposed in the other one. Update with your table and column name in place of Age and [DOB].  This expression assumes you want a DAX calculated column.

Date Turns 60 = DATE(Year(Age[DOB])+60, MONTH(Age[DOB]), DAY(Age[DOB]))

Regards,

Pat