problem with userrelationship

[jppuam]

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, and the table below with the result that i needed.

I've try to use USERELATIONSHIP function but i cant make it work (is like i make a full join of the tables) . The key between them is "Key". Can you help me with this problem ?

Thanks,

JP

[parry2k · Accepted solution]

@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]

@jppuam 

I Think @parry2k suggestion is Good, however There is another way in my opinion which is to create another column combining both project id and sub project id and apply use relationship . Even the Dimension table should have the combined column in this case

[jppuam]

Hi VijayP

But thats what is the Key (concatenate Project and subproject).

How do you use userelationship in this case to give me the final table ?

thanks

JP

[VijayP]

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]

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]

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]

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

thanks for all the help,

JP

[parry2k]

@jppuam it will be easier to append these tables in the Power Query and then remove duplicate rows so you have the final table with the output you are looking for.

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.⚡