Forum Discussion

pasdeblaz's avatar
pasdeblaz
New Member
2 years ago
Solved

Relations Date Between Multiple Tables

Hello,   I think this is a pretty basic issue but I can't find the solution for it. I have the following table : As you can see, we have two dates on the same line. So with Power Query, ...
Need Help
  • CoreyP's avatar
    CoreyP
    2 years ago

    How did you create the 2nd table in Power Query? Did you duplicate the query or use reference? 

     

    Additionally, you can't have two active relationships from a date table to two date columns in the same table. However, you can use inactive relationships. You can need to write your DAX measures to account for them by using CALCULATE and USERELATIONSHIP.

CoreyP's avatar
CoreyP
Solution Sage
2 years ago

How did you create the 2nd table in Power Query? Did you duplicate the query or use reference? 

 

Additionally, you can't have two active relationships from a date table to two date columns in the same table. However, you can use inactive relationships. You can need to write your DAX measures to account for them by using CALCULATE and USERELATIONSHIP.

pasdeblaz's avatar
pasdeblaz
New Member
2 years ago

I used reference for both tables (Sales and Buy) from the Total table.

1. Yes I was aware of that, that's why I tried to find a solution with making more tables but that's not the correct way to do it, it seems.

 

2. So my current data model could work, but if I want to make KPIs and stuff with the calendar table, I need to use USERELATIONSHIP ?