Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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
Proud to be a Super User!
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
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!
Proud to be a Super User!
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.
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)
i've got it. in my others field in the table was creating a duplication
thanks for all the help,
JP
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |