fbpx

Top 5 Steps to Extract Age Using Date in Power Query

Learn How to Extract Age using Date in Power Query. This is an amazing feature as it allows you to extract the age out of the date provided. Let us elaborate on this feature using an example. There are more similar functions that are very much useful in Power Query for Data Cleaning and Data Transformation Techniques. For that Join Our Complete Power Query Training with Lifetime Access and 24×7 Support.

Steps to Extract Age Using Date With Power Query

Here, we have a data table containing employee information which includes their Date of the Birth column. If you want to calculate the age of each employee it will consume a lot of time. To overcome this, Power Query has a solution that can solve this problem within a fraction of second.

MICROSOFT POWER QUERY FOR BEGINNERS
• Course Certificate • Lifetime Access & Free Updates • Lifetime Support • Career Focused

 

Step 1: Select Column before Adding Age

To add an age column, we first have to select the DOB (date of Birth) column as shown in the picture below.

SELECT COLUMN FOR ADDING AGE

Step 2: Calculate Age from Date Column

To calculate age using DOB column in Power Query, go to-

Add Column  >  Date  >  Age

CALCULATE AGE FROM DATE COLUMN

Step 3: After Age Column for Formatting

After you add the age column it is presented in the time format. To convert it into years you need to first select the column as shown below.

AFTER ADDING AGE COLUMN

Step 4: Convert Age from Time to Years Format

To convert age column from time format to years format, go to-

Transform  >  Duration  >  Total Years

CONVERT AGE FROM TIME TO YEARS FORMAT

MICROSOFT POWER QUERY TRAINING
• 100+ Video Tutorials • 15 Case Studies • 2 eBooks • 10 Presentation Decks • 2 Webinar • 24*7 Dedicated Support

 

Step 5: Round Down Age Column

After selecting the Total Years option, your Age column will get converted into age. To round down the age click on the Rounding option and select Round Down. The picture below shows the final output.

AFTER CONVERTING DATE TO AGE

You can learn more :

Conclusion:

In this blog, we will learn about How to Extract Age using Date in Power Query Step-by-Step.

Step1: Select Column before Adding Age
Step2: Calculate Age from Date Column
Step3: After Age Column for Formatting
Step4: Convert Age from Time to Years Format
Step5: Round Down Age Column