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

[Anonymous]

I have these two tables - with no natural connection:

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

[PabloDeheza · Accepted solution]

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!

[Anonymous]

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