Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How To Link Columns With Almost Same Values But Power BI Only Choose One

Hi,

 

From the screenshot, 2 colums from different tables contain the same word but upon linking them (many to many) and try to add a field power value (net) from one of the column the rest table goes blank see screenshot 3.

 

Any idea how to fix this problem?

 

 

 

 

 

Need Help

8 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    2 years ago

    Any idea how to fix this problem? - clean the data. There's no point trying to do anything until you make the names the same in different tables

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    Thanks for the solution HotChilli  provided and i want to offer some more information for user to refer to .

    hello Anonymous , based on the picture you have offered, you can refer to the following solution.

    Sample data 

    Table1

    Table2

    You can create a new column in Table 2 to query the same words in Table 1 as those in Column 1.

    Related_name = MAXX(FILTER('Table1',CONTAINSSTRING([Column1],[Type])),[Type])

    Then you can use the new column to create relationship with table1.

    Best Regards!

    Yolo Zhu

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

    How To Link Columns With Almost Same Values But Power BI Only Choose One.pbix27 KB
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    Thanks for the solution HotChilli  provided and i want to offer some more information for user to refer to .

    hello Anonymous , based on the picture you have offered, you can refer to the following solution.

    Sample data 

    Table1

    Table2

    You can create a new column in Table 2 to query the same words in Table 1 as those in Column 1.

    Related_name = MAXX(FILTER('Table1',CONTAINSSTRING([Column1],[Type])),[Type])

    Then you can use the new column to create relationship with table1.

    Best Regards!

    Yolo Zhu

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

    How To Link Columns With Almost Same Values But Power BI Only Choose One.pbix27 KB
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks for the help. Being new in this forum I need to assistance on a few simple questions

       

      1.  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Will I just need to reply Accept in this thread?

       

      2. I need to move my fabric account from my office email address to my personal outlook. How do I that?

       

      3. If I was able to move the fabric account to my outlook, will I still be able to see the post(s) I created using my company email?

       

      //tksnota

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

        Thanks for your quick reply.

        for the first question, there is a 'Accept as a Solution' button in the bottom right corner, if you think the message I provided will help you, you can click on the Accept as a Solution' button in the bottom right corner of my message.

        for the second question, power bi need the officcal account from school or company, if you change it to your personal email account, it may cannot log in, you can refer to the following link.

        https://learn.microsoft.com/en-us/power-bi/fundamentals/service-self-service-signup-for-power-bi#supported-email-addresses

         

        Best Regards!

        Yolo Zhu

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