Forum Discussion

Hind26's avatar
Hind26
Icon for Advocate I rankAdvocate I
8 years ago

Multiple relationships with Date report filter

Hi, I have a Fact Table that contain two different Date (exple : Creation and Update) and i have Date Dimension, beside all this i have a Date Report filter that i did from my Date dimension and i w...
Need Help
rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
8 years ago

You can make relationship on these two dates.One active and another one inactive.

 

You can create active relationship on the one that is used most while calculating a measure , and can use USERELATIONSHIP whenever you want to use other date.

 

Hope this helps,

Thanks!

Hind26's avatar
Hind26
Icon for Advocate I rankAdvocate I
8 years ago

Thank you for your answer, i have already tried this solution, but i figured out that using the function UseRelationship on the inactive relationship inactivate the other one, it doesn't work in addition on my existing active relationship.

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Sorry , but you cannot have more than one relationship between two tables.

    • Hind26's avatar
      Hind26
      Icon for Advocate I rankAdvocate I
      8 years ago

      So there is any other possible way to filter on the Report Date filter and my two dates be automatically included in the range chosen by the user in the filter? 

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Hind26,

         

        It is not possible to create multiple relationships between two tables. You want to make both two date columns to be affected by the single Report filter, right? You could use MAX(Date Dimension[Dates]) to get the selected date value, then use this expression to filter records through a measure. In that case, you don't need to create any relationship between Fact Table and Date Dimension.

         

        Best regards,

        Yuliana Gu