How to replicate "userelationship" (power bi) in looker?

[esteban_baigorr]

Hi guys!

The problem I’m facing is that in one fact table there are two dates:

-Start date

-End date

So, in power bi with “userelationship”(1) function I can choose whenever I want to use the start-date or the end-date in measures because when these dates are both joined to the date column in the calendar table they get deactivated and you have to activate the relations through the function(1).

But, in looker I have no idea how to replicate this behavior, because if the start date is joined to the calendar view, then ‘Startdate’ will be used for ALL the metrics.

And if I join both startdate/enddate I think that then it will create a join that meets startdate=enddate=calendardate. Which is unwanted.

I’m thinking of creating a new view with the fact table or a new calendar view, but it doesn’t seem to be user friendly.