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!
2 Replies
- PabloDeheza
Solution Sage
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!