Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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.

Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can make a DAX calculation column  with this formula to get your result.

     

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

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    You can make a DAX calculation column  with this formula to get your result.

     

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