Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Age in the future?

‎12-10-2020 09:10 AM

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.

Labels:
Message 1 of 2
388 Views
0
1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

‎12-10-2020 09:27 AM

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




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

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Message 2 of 2
377 Views
0
1 REPLY 1
mahoneypat
Employee
Employee

‎12-10-2020 09:27 AM

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




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

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Message 2 of 2
378 Views
0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All