Syntax Error in List.Generate Function

[ctrip77]

Hi everyone!

Im trying to do a date list (in power Query), starting on a given date and then get the next 4 years.

I did this:

List.Generate(()=> [ x = 1 , y = {}] , each [x] <= 4 , each [x = [x]+1] , each Date.AddYears([Date_start] ,1) )

But Im receiving error, I dont know where is my syntax error, if anybody see it or if there is another solution I would appreciate.

thanks in advance!

[ctrip77 · Accepted solution]

ok, found it:

List.Generate( () => [ a = [Date_start], b = Date.AddYears([Date_start] ,4) ], each [a] <= [b], each [ a = Date.AddYears( [a], 1 ), b = [b] ], each [a] )

[PattemManohar]

@ctrip77  Please try this as a "Custom Column" in Power Query Editor.

=List.Numbers(Date.Year([hiredate])+1,4)

[HotChilli]

Try this technique (which is good to learn for lots of other functions too)

https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/