Power querry Join

[akpresta]

Hello everyone,

I really need help from the great community

In the PJ file, I have a dashboard tab "TDB" where there is information, I want to update (replace) them according to the "UPDATE" tab.

Except that my problem is the following: in the base file "TDB" I have ID TRADE NAME which represents a key between the two files except that I cannot use search V because there are duplications of lines and that the table join creates too many excess rows.

Have you ever had to deal with this type of case?

Many thanks for your help

A.K.

Spoiler

"TDB"

Nom	Prénom	id tade	date d'entrée de le portefeuille	Pays	type
TEST0	TEST7	B97383	10/10/2023	FR	TYPE 1
TEST2	TEST6	B427667	11/10/2023	ES	TYPE 1
TEST6	TEST6	B673667	12/10/2023	UK	TYPE 3
TEST6	TEST2	B512009	13/10/2023	USA	TYPE 1
TEST6	TEST2	B512009	13/10/2023	USA	TYPE 1
TEST4	TEST9	B699089	14/10/2023	IR	TYPE 1
TEST4	TEST9	B699089	14/10/2023	TK	TYPE 1
TEST5	TEST8	C418393	15/10/2023	IT	TYPE 3
TEST3	TEST9	C650815	16/10/2023	FA	TYPE 1
TEST5	TEST3	C305766	17/10/2023	FR	TYPE 1
TEST5	TEST3	C305766	17/10/2023	SP	TYPE 1
TEST0	TEST7	C912205	18/10/2023	ES	TYPE 3
TEST4	TEST3	C908759	19/10/2023	UK	TYPE 1
TEST3	TEST2	C644895	20/10/2023	USA	TYPE 1
TEST6	TEST10	C510078	21/10/2023	MA	TYPE 3
TEST9	TEST5	C987474	22/10/2023	IT	TYPE 1
TEST9	TEST3	C526980	23/10/2023	FA	TYPE 3
TEST10	TEST0	C607672	24/10/2023	RA	TYPE 2

"MAJ"

id tade	date d'entrée de le portefeuille	Pays	type
B97383	10/10/2023	FR	TYPE 1
B427667	20/12/2022	IT	TYPE 1
B673667	21/12/2022	DZ	TYPE 3
B512009	13/10/2023	USA	TYPE 1
B699089	14/10/2023	MA	TYPE 1
C418393	15/10/2023	IT	TYPE 3
C650815	16/10/2023	FA	TYPE 1
C305766	17/10/2023	FR	TYPE 1
C912205	18/10/2023	ES	TYPE 3
C908759	19/10/2023	UK	TYPE 1
C644895	20/10/2023	USA	TYPE 1
C510078	21/10/2023	MA	TYPE 3
C987474	22/10/2023	IT	TYPE 1
C526980	23/10/2023	FA	TYPE 3
C607672	24/10/2023	RA	TYPE 2
B699089	14/10/2023	BA	TYPE 1
B699089	14/10/2023	BO	TYPE 1
B699089	14/10/2023	BC	TYPE 1

[amitchandak · Accepted solution]

@akpresta , One of the ways is to have common dimensions and deal with such tables

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

[akpresta]

thank you very much 🙂