cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sander84
Helper II
Helper II

Power Query - Birth date to age

Hello community members, 

 

Any help would be welcome! 

 

I have a column with BirthDate (e.g. 24-6-1983) 

How can I transform this BirthDate in Power Query to the Age of the person (based on date TODAY). 24-6-1983 --> 37

 

Hope to hear soon from you! 

 

Cheers, Sander

1 ACCEPTED SOLUTION
ERD
Solution Sage
Solution Sage

Hi @Sander84 ,

Here is an article with the solution: https://radacad.com/age-calculation-in-power-bi-using-power-query.

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
ERD
Solution Sage
Solution Sage

Hi @Sander84 ,

Here is an article with the solution: https://radacad.com/age-calculation-in-power-bi-using-power-query.

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

View solution in original post

Hi @ERD , 

 

OMG, is it really that simple... Thanks for sharing this information! 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

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

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors