Forum Discussion
Cross join tables
Hi! I need help cross joining two tables. I have one table that looks like this: Table "Openings hours" Store Weekday Hours open Store 1 Mo 8 Store 1 Tu 7 Store 1 We ...
In the Query Editor, you can merge Opening Hours table onto the Dim Date table joining on Weekday and then expand the Store and Hours open columns.
Anonymous ,
Step 1: Join the two tables based on the Weekdays.
Step 2: Then drag the Stores, date, and hours open from the respective tables on Table visual.