The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
How do I calculate the duration between two dates in Years and/or months (not days) in Power Query
I need to insert a column which will show the age of the customer when they purchased their product. I have their date of birth and the transaction date - I need to report on the age of customer at transation date in Years.
Thanks in advance
Solved! Go to Solution.
I was being lazy and forgtot to round decimal places....
= Table.AddColumn(#"Changed Type", "Years", each Number.Round(Duration.Days([Purchase] - [Birth])/365,2), type number)
this is great James - I will give it a try now - Im assuming I go to powerquery - add column - custom column ?
Yea thats correct, let me know if you get stuck and I can add screenshots.
Thanks,
Hi,
Give this a go (assumed coumns are called Birth and Purchase)
= Table.AddColumn(#"Changed Type", "Years", each Duration.Days([Purchase] - [Birth])/365, type number)
Thanks,
I was being lazy and forgtot to round decimal places....
= Table.AddColumn(#"Changed Type", "Years", each Number.Round(Duration.Days([Purchase] - [Birth])/365,2), type number)