I can do this in Excel, no problem. However I want to do it in PQ. I have a list of renewal dates for subscriptions, I need to get the corresponding start dates but using the years' duration of subscription...e.g. a renewal date is 31/1/2019, the number of years is 1, therefore I want PQ to show me the start date as 31/1/2018...have looked at the duration options but can't find anything there...
Hi Anne,
You can use Date.AddYears like so:
=Date.AddYears([Renewal Date],-[Years])
Mynda
Brilliant - thanks a mil. Is it wrong to say I love you and want to have your Excel babies 🙂 in a MMMMM sort of way 🙂
You can use
=DATE((YEAR(Renewal Date)-Years),MONTH(Renewal Date),DAY(Renewal Date))
@Vasim, that is an Excel formula. Anne needed a Power Query formula, which is what I provided above.
@Anne, 😀
