Forum Discussion
Solved
Syntax Error in List.Generate Function
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]+...
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
Community Champion
Community Championctrip77 Please try this as a "Custom Column" in Power Query Editor.
=List.Numbers(Date.Year([hiredate])+1,4)