Power querry Join

Question

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 (Highlight to read)"TDB"Nom&nbsp;Prénom&nbsp;id tadedate d'entrée de le portefeuillePaystypeTEST0TEST7B9738310/10/2023FRTYPE 1TEST2TEST6B42766711/10/2023ESTYPE 1TEST6TEST6B67366712/10/2023UKTYPE 3TEST6TEST2B51200913/10/2023USATYPE 1TEST6TEST2B51200913/10/2023USATYPE 1TEST4TEST9B69908914/10/2023IRTYPE 1TEST4TEST9B69908914/10/2023TKTYPE 1TEST5TEST8C41839315/10/2023ITTYPE 3TEST3TEST9C65081516/10/2023FATYPE 1TEST5TEST3C30576617/10/2023FRTYPE 1TEST5TEST3C30576617/10/2023SPTYPE 1TEST0TEST7C91220518/10/2023ESTYPE 3TEST4TEST3C90875919/10/2023UKTYPE 1TEST3TEST2C64489520/10/2023USATYPE 1TEST6TEST10C51007821/10/2023MATYPE 3TEST9TEST5C98747422/10/2023ITTYPE 1TEST9TEST3C52698023/10/2023FATYPE 3TEST10TEST0C60767224/10/2023RATYPE 2"MAJ"id tadedate d'entrée de le portefeuillePaystypeB9738310/10/2023FRTYPE 1B42766720/12/2022ITTYPE 1B67366721/12/2022DZTYPE 3B51200913/10/2023USATYPE 1B69908914/10/2023MATYPE 1C41839315/10/2023ITTYPE 3C65081516/10/2023FATYPE 1C30576617/10/2023FRTYPE 1C91220518/10/2023ESTYPE 3C90875919/10/2023UKTYPE 1C64489520/10/2023USATYPE 1C51007821/10/2023MATYPE 3C98747422/10/2023ITTYPE 1C52698023/10/2023FATYPE 3C60767224/10/2023RATYPE 2B69908914/10/2023BATYPE 1B69908914/10/2023BOTYPE 1B69908914/10/2023BCTYPE 1"TDB"Nom&nbsp;Prénom&nbsp;id tadedate d'entrée de le portefeuillePaystypeTEST0TEST7B9738310/10/2023FRTYPE 1TEST2TEST6B42766711/10/2023ESTYPE 1TEST6TEST6B67366712/10/2023UKTYPE 3TEST6TEST2B51200913/10/2023USATYPE 1TEST6TEST2B51200913/10/2023USATYPE 1TEST4TEST9B69908914/10/2023IRTYPE 1TEST4TEST9B69908914/10/2023TKTYPE 1TEST5TEST8C41839315/10/2023ITTYPE 3TEST3TEST9C65081516/10/2023FATYPE 1TEST5TEST3C30576617/10/2023FRTYPE 1TEST5TEST3C30576617/10/2023SPTYPE 1TEST0TEST7C91220518/10/2023ESTYPE 3TEST4TEST3C90875919/10/2023UKTYPE 1TEST3TEST2C64489520/10/2023USATYPE 1TEST6TEST10C51007821/10/2023MATYPE 3TEST9TEST5C98747422/10/2023ITTYPE 1TEST9TEST3C52698023/10/2023FATYPE 3TEST10TEST0C60767224/10/2023RATYPE 2"MAJ"id tadedate d'entrée de le portefeuillePaystypeB9738310/10/2023FRTYPE 1B42766720/12/2022ITTYPE 1B67366721/12/2022DZTYPE 3B51200913/10/2023USATYPE 1B69908914/10/2023MATYPE 1C41839315/10/2023ITTYPE 3C65081516/10/2023FATYPE 1C30576617/10/2023FRTYPE 1C91220518/10/2023ESTYPE 3C90875919/10/2023UKTYPE 1C64489520/10/2023USATYPE 1C51007821/10/2023MATYPE 3C98747422/10/2023ITTYPE 1C52698023/10/2023FATYPE 3C60767224/10/2023RATYPE 2B69908914/10/2023BATYPE 1B69908914/10/2023BOTYPE 1B69908914/10/2023BCTYPE 1&nbsp;

amitchandak · Accepted Answer

akpresta , One of the ways is to have common dimensions and deal with such tables
&nbsp;
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geMhttps://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

Forum Discussion

Power querry Join

2 Replies

Related content

Cant find ribbon framework on power querry

Date.ToText Power Querry issue

conditional join

Join the community

Power BI Pl 300 exam questions - Inner Join, Left outer Join and Right Join

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