cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Somebodys age in the future?

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.

1 ACCEPTED SOLUTION
Super User IV

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

Super User IV

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

Announcements

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks