Forum Discussion

AndreasAh's avatar
AndreasAh
Frequent Visitor
4 years ago

How to handle multiple relationships in Power BI

Hi,   (I'm sorry the text editor completley butchered my task when it tried to format my tables)   I've read several posts here on this topic but I've not been able to find a solution that works ...
Need Help
v-xiaosun-msft's avatar
v-xiaosun-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi AndreasAh ,

 

According to your description, I wonder whether you can describe the relationships between four tables more clearly in order that we can better help you.

Mind that you can try QUARTER function which can return the quarter of one date. You can use it to show the quarter of completed date.

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AndreasAh's avatar
AndreasAh
Frequent Visitor
3 years ago

Thank you for your reply.

So As I tried to illustrate above, I have 6 tabels:

1. Table A (active relationship with Table A support)

2. Table A support

3. Table B (active relationship with Table B support)

4. Table B support

5. Table containg my measurments (unrelated)

6. Table for Calendar (unrelated)

 

I want all tables (1,2,3,4 and 6) to related to my Calendartable and hence all graphs have the same basis.

  • KNP's avatar
    KNP
    Icon for Super User rankSuper User
    3 years ago

    The BEST way to solve this is to do the data modelling in Power Query to get the tables into a star schema.

    Merge, create dimensions, whatever else you have to do to simplify the relationships.

    It will be solvable in DAX but it is the WRONG way to do it and will only complicate all future DAX you need to write for this model.

    If you can share a screenshot of your entire model you may get some suggestions on how best to acheive this.