Merge a Calendar Table and Items Table into one table

[Danch89]

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

[johnt75 · Accepted solution]

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