Forum Discussion

LiNSiCKeL's avatar
LiNSiCKeL
New Member
8 months ago
Solved

Linking Two Tables with Multiple Entries

As I understand this is a relationship problem, but I am unsure how to properly link these items to get it to function correctly.    Both tables have many projects each having their own set of acti...
Need Help
  • LiNSiCKeL's avatar
    LiNSiCKeL
    8 months ago

    Solutions did not work as desired, in the end power query ammending the tables got a result that worked. 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 months ago

Hi,

In Power Query, create a table witha single column of all unique activities.  Create a Many to One relationship from the 2 existing tables to this third table.  To your visual, drag Activity from the 3rd table.

  • v-achippa's avatar
    v-achippa
    Community Support
    8 months ago

    Hi LiNSiCKeL,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you AntoineW, FBergamaschi and Ashish_Mathur for the prompt response. 

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      8 months ago

      Hi @LiNSiCKeL,

       

      We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • LiNSiCKeL's avatar
        LiNSiCKeL
        New Member
        8 months ago

        Solutions did not work as desired, in the end power query ammending the tables got a result that worked.