Merging queries One to Many

[Nick2358]

Hello everyone,

Here is my problem today. I have 2 tables that I want to merge to have combined information. 

Table1 has the name showing once and Table2 has the name showing several times.

Table1                                 Table2

Name                                  Name                           Status

Merchant X                         Merchant X                  Processing

                                            Merchant X                  Null

                                            Merchant x                   Null

My issue is Merchant X will show three times as "Null" and I need to show it once as "Processing" and twice as "Null" in my Matrix. 

Does anyone know how I can do that? 

Of course I use Table1 because of other info in this table otherwise I'd only use Table2 😉 

Thanks,

Nick,

[v-alq-msft]

Hi, @Nick2358 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may go to 'Query Editor' and add an index column.

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Your explanation and your sample don't match.  Please be more specific.  Merging a single cell table with another table has no effect whatsoever.