Forum Discussion

MH's avatar
MH
Regular Visitor
9 years ago
Solved

2 dates to one Calendar

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 da...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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