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   ...
  • johnt75's avatar
    4 years ago
    New Table = CROSSJOIN( VALUES( 'Date'[Date]), VALUES('Items'[Item ID]) )