Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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] )
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] )
@ctrip77 Please try this as a "Custom Column" in Power Query Editor.
=List.Numbers(Date.Year([hiredate])+1,4)
Proud to be a PBI Community Champion
Try this technique (which is good to learn for lots of other functions too)
https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |