Forum Discussion
Powery Query #date function
You don't need hard coded values: this function works perfectly fine;
Edit: If you are looking for alternatives then please specify exactly what should happen.
E.g. you can create a series of numbers and then change the type to date.
Or you can use List.Dates.
E,g, this fuction creates a table with1 column with 10 dates:
(Year as number, Month as number, Day as number) => Table.FromColumns({List.Dates(#date(Year,Month,Day),10,#duration(1,0,0,0))}, type table[Date as date])
You don't need #date if you have a date in a single row, single column table. Just load it up and change to format to type date if needed
You don't need hard coded values: this function works perfectly fine;
Edit: If you are looking for alternatives then please specify exactly what should happen.
E.g. you can create a series of numbers and then change the type to date.
Or you can use List.Dates.
E,g, this fuction creates a table with1 column with 10 dates:
(Year as number, Month as number, Day as number) => Table.FromColumns({List.Dates(#date(Year,Month,Day),10,#duration(1,0,0,0))}, type table[Date as date])Thanks MarcelBeug. I was able to adopt a concept from your reply to make my effort work. I replicated my single cell query 3 times so that I could convert each component (year, month, and day) into lists. So I ended up with 3 list queries. I was then able to create parameters (query option) on each of those. I was then able to create a new query that used those parameters to generate a list of dates. Not sure if my solution is the best way to go about this but at least its dynamic and automated and gets me what I want.
