A date for each record

[carlosarmpb]

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).

[Greg_Deckler · Accepted solution]

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.

[Greg_Deckler · Accepted solution]

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.

[carlosarmpb]

THANKS !!!

That's exactly what I needed.

[carlosarmpb]

Just one more question!

Eu consigo fazer isso no editor de consultas?

[Greg_Deckler]

Maybe, but that is a question for @ImkeF

[carlosarmpb]

Thanks!

[ImkeF · Accepted solution]

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.

[carlosarmpb]

Perfect!

Thanks