Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Relationship between multiple sources

Hello to all, I am having currently an issue linking in a correct way the information marked with red. Basically, i would need to link the following: 1)production date from BI_Daily_confirmed with...
Data Protection
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    In your screenshot, I see that there is a many-to-many relationship between the two tables. This should be the cause of the problem. If you can create a bridge table based on the corresponding fields, and then make a one-to-many connection, it may be improved. Otherwise, you need to manually obtain the corresponding data by creating measures.

    If you can understand what I say, and still need help, please share some sample fake data and your desired result and feel free to ask me.

     

    Best Regards

    Janey Guo

     

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

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Anonymous 

 

In your screenshot, I see that there is a many-to-many relationship between the two tables. This should be the cause of the problem. If you can create a bridge table based on the corresponding fields, and then make a one-to-many connection, it may be improved. Otherwise, you need to manually obtain the corresponding data by creating measures.

If you can understand what I say, and still need help, please share some sample fake data and your desired result and feel free to ask me.

 

Best Regards

Janey Guo

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    Thanks for reply. I will check your proposal and return with feedback. I am quite new with PowerBi, but, willing to learn 🙂

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      5 years ago

      Hi, Anonymous  Any updates?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hello,

         

        Not yet. I tried some days ago to create this bridge table, but i thik i missed some steps and the result is not what i was looking for. I need some time more, as i have other urgent topics ongoing. I will let you know if i get stuck at some point.