Forum Discussion
Post PatronBridge tables won't work together with date table
I've just created a date table which now works fine with "Magento - Order Line" and, "Magento - Order", but "GA - Product"
does not work when I change the date with my 'Calendar'[date].
I tried to make bridge tables to connect them together, but this gives no result.
My relationships look like this:
Year is connected with Year (As they are noted as "2018, 2019, etc.)
Month of year is connected with MonthLong (As they are noted as "January, February, etc.)
My bridge tables looks as followed:
"GA / Order Line - Year":
"GA / Order Line - Month":
Niels_T , with month of year and year, create date and use that to join directly with date table
If month of year is a number
Date = date([year],[month of year],1)
or if it is month name
Date = "01-" & [month of year] & "-" &[Year]
Change data type to date and use
1 Reply
- amitchandak
Super User
Niels_T , with month of year and year, create date and use that to join directly with date table
If month of year is a number
Date = date([year],[month of year],1)
or if it is month name
Date = "01-" & [month of year] & "-" &[Year]
Change data type to date and use