Microsoft Office Forums - View Single Post - Calculate age in power query as of a given date

Thread: Calculate age in power query as of a given date

View Single Post

Old

11-11-2020, 07:47 PM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2013

Marcia uses Office 2013

Office 2013

Expert

The original poster

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Calculate age in power query as of a given date

Hi. I know how to calculate the age of persons in PQ from DOB to TODAY under the Date tool of the Add Column tab. I want to add another column that will compute the age from DOB to December 31, 2020. I could not find a solution in my search.
Thank you.

Reply With Quote