Forum Discussion

jppuam's avatar
jppuam
Helper V
5 years ago
Solved

problem with userrelationship

Hello, i want to conbine information from two tables but they are connected to other tables and i cant make it right according to what i need. I've made a picture with the data from table A and B, ...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    jppuam Although what VijayP is suggesting would work but I believe (trust me), appending the tables in Power Query is your best otherwise you are going to do un-necessary work with DAX, if you have to create another DImension table, means you need all the keys in that table and it goes back to appending the table in the Power Query.

     

    Good luck!

     

    Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

VijayP's avatar
VijayP
Community Champion
5 years ago

Create a Dim Table Having The conctenated Field and Connect that to one Fact Table and then use relation ship to bring other table values here!

 

jppuam's avatar
jppuam
Helper V
5 years ago

i dont understand why its not working. Now, i even create a summarize and then connected to the table 2, and shows always 2 lines per record.

  • jppuam's avatar
    jppuam
    Helper V
    5 years ago

    what i needed is that i join the data from the two tables, and put the % progress in the fields that as on table 1 (and empty on those who came from table 2)

    • jppuam's avatar
      jppuam
      Helper V
      5 years ago

      i've got it. in my others field in the table was creating a duplication

      thanks for all the help,

      JP