Which sequence of merging steps does produce the desired table?

[Anonymous]

Hi! I found the following exercise which is rather confusing to me:

I know the different types of merging in Power BI (inner join, left outer joing etc.) but I do not understand what is the aim of this exercise, i.e., which table has to be achieved here.

For example, if I perform the first option in the possible answers, i.e. if I merge [Region_Manager] and [Manager] by using an inner join, what I get is a table with rows where each row (if not empty) contains a manager ID with corresponding manager name and, moreoever, a corresponding region ID.

[v-cgao-msft]

Hi @Anonymous ,

I make a simple model:

"Only managers who are associated to a sales region must be included in the reports."

Based on this description, I think the final table I want to get is similar to this.

I have provided one method in the document, but as the title says, there are different methods and understanding the steps will help in learning Merge querying.

Merge queries overview - Power Query | Microsoft Learn

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

Hi @v-cgao-msft 

In your model, in the second table (which is your example for the table Region_Manager), I think the second column shown in red is manager_id but you wrote manager names in this column, don't you?

Also in your final table, the third column should be Region_Manager.manager_id, or?