How to create a custom PQ Calendar using Start and End date parameters cells

[Luthius]

Guys, I would like to know how to create a custom Power Query Calendar using Start and End date parameters based in my cells values.
The values in my worksheet can be changed by the user. The calendar will be generated based on the table Start and End Information.

Start	End
01/01/2020	01/01/2021

This calendar table I will use on another data table that I will transform.

 

[sandy666]

You are welcome

I know nothing about VBE because I don't like it
more about PowerQuery aka Get&Transform

• What is PowerQuery (Get&Transform)
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference (erratum required)

It's nice to see if someone appreciate your work so I like Like in appropriate posts

Have a nice day

 

[Luthius]

Do you think is possible incorporate this Calendar table with the values of a table I have in my spreadsheet? I mean, each date in my calenda will apear in my another table, doenst matter if the date exist or not on the other table.

Before

Products	Date	Value
Product A	20/09/2020	10
Product A	07/09/2020	10
Product A	04/12/2020	10

After

Products	Calendar Table date	Value
Product A	01/01/2020	10
Product A	02/01/2020	10
Product A	03/01/2020	10
Product A	04/01/2020	10
Product A	05/01/2020	10
Product A	06/01/2020	10
Product A	07/01/2020	10
Product A	...	10

 

[sandy666]

this is different question so start new thread

 

[Luthius]

Thanks. already create another one.