Forum Discussion
Solved
A date for each record
I believe that my doubt is simple, I have a query with product codes and i want that for each of these records have the date (the 365 days of the year).
Tough to say exactly because I'm not sure what you want. But, if you had that table and you create a Calendar table like:
Calendar = CALENDAR(DATE(2018,1,1),DATE(2018,12,31))
Then you could do this:
Table = GENERATE(productstable,Calendar)
It's a DAX solution, not Power Query.
In the query editor you would add a column with this formula:
List.Dates(#date(2018,01,01),365,#duration(1,0,0,0))
Just expand the column then.
7 Replies
- Greg_Deckler
Community Champion
Tough to say exactly because I'm not sure what you want. But, if you had that table and you create a Calendar table like:
Calendar = CALENDAR(DATE(2018,1,1),DATE(2018,12,31))
Then you could do this:
Table = GENERATE(productstable,Calendar)
It's a DAX solution, not Power Query.
THANKS !!!
That's exactly what I needed.
Just one more question!
Eu consigo fazer isso no editor de consultas?
