Forum Discussion
Match Data in Power BI Desktop
Hello Guys,
I am new using power bi, and need to relate two tables that share a common column ("Clients"), it means, data with the same information
My problem is that in one column I have 10 different clients and in the other I have only 6 that coincide, and 2 that do not
For this reason,PBI does not allow me relate the two tables.
Some idea of how to relate the two columns, since later its gona be imposible do it manually
Please I need some help
13 Replies
Hi,
Using the query editor, append the Clients column from both tables and remove duplicates. Now create a realtionship from the Clients from of both tables to this third table. In any visual, drag the clients column from the third table.
Hope this helps.
Hello Ashish_Mathur
What do you mean with append both colums... create a thrid appended table with all the clients?
So, then what is the way to combine the values of the each same Client with the columns of the two different tables
For example:
I want to have the line like these
10002 10:00 14:00 11:00 1
Please Help me
Hi,
Please show your datasets and your expected result.
