Match

[Samikshadixit]

I have two tables and both have uniques key based on the key I wanted to get customer name for the accounts, one account has multiple customer name ,i want that based on key match i get all the customer name for each account and if key dosent match than return blank

[ryan_mayu]

@Samikshadixit 

you can use merge in the PQ.

pls check the combine queries in the turotial below

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

[amitchandak]

@Samikshadixit ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Samikshadixit]

		Main Table
Account ID	Account Name	Country	Key (AccountID& Country)	Customer Name
12	Pink	UnitedState	12UnitedState
16	Blue	Canada	16Canada
19	Green	Singapore	19Singapore
42	Yellow	Malaysia	42Malaysia
78	Orange	India	78India

Seconed Table
Account ID	Account Name	Country	Key (AccountID& Country)	Customer Name
12	Pink	UnitedState	12UnitedState	DILIP
12	Pink	UnitedState	12UnitedState	Sheyansh
12	Pink	UnitedState	12UnitedState	Amit
16	Blue	Canada	16Canada	Ram
16	Blue	Canada	16Canada	Gaurav
16	Blue	Canada	16Canada	Shipra
19	Green	Singapore	19Singapore	Deepak
19	Green	Singapore	19Singapore	Shibu

		Result Table
Account ID	Account Name	Country	Key (AccountID& Country)	Customer Name
12	Pink	UnitedState	12UnitedState	DILIP
12	Pink	UnitedState	12UnitedState	Sheyansh
12	Pink	UnitedState	12UnitedState	Amit
16	Blue	Canada	16Canada	Ram
16	Blue	Canada	16Canada	Gaurav
16	Blue	Canada	16Canada	Shipra
19	Green	Singapore	19Singapore	Deepak
19	Green	Singapore	19Singapore	Shibu
42	Yellow	Malaysia	42Malaysia	Blank
78	Orange	India	78India	Blank

[ryan_mayu · Accepted solution]

@Samikshadixit 

pls review the tutorial I provided. You can use Merge function in PQ to get the expected result