Image: Susan Harkins/TechRepublic. Load the data into Power Query. Once the data, including the date of birth, is in Power Query, you can add an age column as follows: Select the date of birth column.