Calculate age in power query as of a given date

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate age in power query as of a given date

FAQ

Mark Forums Read

Thread Tools

Display Modes

11-11-2020, 07:47 PM

Marcia

Windows 7 32bit Calculate age in power query as of a given date

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove delimiters in merged columns in power query when null	Marcia	Excel	2	11-06-2020 09:42 PM
Format numbers in Power Query	Marcia	Excel	2	09-21-2020 12:59 AM
Do I need a power query for this one?	shabbaranks	Excel	5	04-10-2019 03:29 AM
Issues Using Power Query file in Excel 2016 and then in 2013	bld9936	Excel Programming	0	02-27-2017 12:50 PM
Query and Power Query not working Excel 2016	bl10	Excel	0	07-22-2016 06:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:05 PM.