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 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  :smileyhappy:

 

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

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    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