List.Dates.LastNYears.pq

// last N years
(N as number) =>
	let
		start = Date.StartOfYear(Date.AddYears(Date.From(DateTime.FixedLocalNow()), -N)),
		end = Date.EndOfYear(Date.AddYears(Date.From(DateTime.FixedLocalNow()), -1)),
		result = List.Dates(start, Duration.Days(end - start) + 1, #duration(1,0,0,0))
	in 
		result