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

MFelix's avatar
MFelix
Super 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