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
If you want to do this in a visual in the report, you can use:
1)
Sum of hours = SUM('Opening Hours'[Hours open])2)
Hours by date =
CALCULATE (
[Sum of hours],
TREATAS ( VALUES ( 'Date Table'[Weekday] ), 'Opening Hours'[Weekday] )
)and create the visual using the Date field from the Date Table and the Store from the Opening Hours Table: