Incorporate dates from a Calendar Table Query into another table

[Luthius]

Guys
I have the following table in my spreadsheet and I want to incorporate every single date from a Calendar Table query into this table.


Before - ProductTable

Products	Date	Value
Product A	31/01/2020	10
Product A	18/03/2020	10
Product A	21/02/2020	10

After - Result with the dates from my Calendar query table

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]

if you want to play with DAX .... ?

I think you should learn first these things

Power Query M formula language reference - PowerQuery M

Power Query M is used to filter, combine, and mash-up data from one or more supported data sources.

docs.microsoft.com

DAX function reference - DAX

Learn more about: DAX function reference

docs.microsoft.com

not just copy/paste