2 dates to one Calendar

[MH]

Hello everyone,

I have 2 column's with a date data and I'm trying to do one calendar.

I tried to do Calendar and connect it to the Effective_Date like this:

But then the date in the calendar ans the date of the Expiration_Date column does not match

What am I doing wrong?
I'd be happy to get help  

[v-huizhn-msft]

Hi @MH,

From your screenshot, you connect Calendar[Date] to ServicePeriod[Effective-Date], so the Calendar[Date] equals to ServicePeriod[Effective-Date] rather than Expirtion data. You need to create a create a relationshiop between Calendar[Date] and  ServicePeriod[Expirtion data].

In addition, what's your requriement? Could you share more details.

Best Regards,
Angelia

[MFelix · Accepted solution]

Hi @MH,

I don't know what is the final result you want but in PBI you can only make one active relation between two tables, What I do to make my calculations is make one of the date relationship active and another one not active and then make my measure for the non active relationship with a USERRELATIONSHIP formula.

What kind of information do you want to show?

Regards,

MFelix