Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |