Forum Discussion
Match
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
pls review the tutorial I provided. You can use Merge function in PQ to get the expected result
4 Replies
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
Samikshadixit ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.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 pls review the tutorial I provided. You can use Merge function in PQ to get the expected result
