Forum Discussion
How to create a new table with duplicate dates and values from an existing table
I have these two tables - with no natural connection: And I want to create this table for all the dates with DAX, please help!
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!
PabloDeheza
Solution Sage
Solution SageHi 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!
Thank you so much! That was exactly what i needed 😊