Forum Discussion
Danch89
4 years agoFrequent Visitor
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 ...
- 4 years ago
New Table = CROSSJOIN( VALUES( 'Date'[Date]), VALUES('Items'[Item ID]) )
johnt75
Super User
4 years agoNew Table = CROSSJOIN( VALUES( 'Date'[Date]), VALUES('Items'[Item ID]) )