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
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
- johnt75
Super User
New Table = CROSSJOIN( VALUES( 'Date'[Date]), VALUES('Items'[Item ID]) )