Forum Discussion

Danch89's avatar
Danch89
Frequent Visitor
4 years ago
Solved

Merge a Calendar Table and Items Table into one table

Hi

 

I have an items table which has a unique list of items and a calendar table which has a single entry for each date. I want to create a new merged table which has a date entry for each item

 

For example the new table would look like this:

 

Date          ItemID

1.1.21        ItemA

1.1.21        ItemB

1.1.21        ItemC

2.1.21        ItemA

2.1.21        ItemB

2.1.21        ItemC

 

  • New Table = CROSSJOIN( VALUES( 'Date'[Date]), VALUES('Items'[Item ID]) )

1 Reply

  • New Table = CROSSJOIN( VALUES( 'Date'[Date]), VALUES('Items'[Item ID]) )