topic How to create a new table with duplicate dates and values from an existing table in DAX Commands and Tips

How to create a new table with duplicate dates and values from an existing table

Anonymous — Tue, 01 Nov 2022 14:53:56 GMT

I have these two tables - with no natural connection:

And I want to create this table for all the dates with DAX, please help!

Re: How to create a new table with duplicate dates and values from an existing table

PabloDeheza — Tue, 01 Nov 2022 15:07:28 GMT

Hi Anonymous!
Try the following:

New Table = VAR _Table1 = VALUES( 'Table 1'[DateShort] ) VAR _Table2 = SUMMARIZE( 'Table 2', 'Table 2'[Category], 'Table 2'[Category 2] ) RETURN CROSSJOIN( _Table1, _Table2 )

Let me know if that helps!

Re: How to create a new table with duplicate dates and values from an existing table

Anonymous — Tue, 01 Nov 2022 15:14:36 GMT

Thank you so much! That was exactly what i needed 😊