How to combine 2 columns from different tables to fill in the blanks

[locka]

A change was made to the way our phones process calls. This has effected how calls travels. This change has changed how we know why the customer called. We use to get this from the [name] column in [queue info] table. As this was queue name and told us what they called for. Our system now has much less queues, but records the reason for calling in a different field with in [call details] table.

I need to work how best to merge two fields together so that data from [Queue Info] table column [name]. Is merged with the [Call details] table column [queue name] to fill in blank rows, that prior to change where never populated. I don't want the data append to bottom, but rather merged so that there are no blanks. Below is a very simple diagram of what we have there are more columns in the tables. However these are the ones that are linked and need to be manipulated.

I need to fill in all blank rows from [Call details] table. That have a blank [queue name]. With correct name from [Queue info] table column [name]. [Queue info] table has one entry for each queue. [Queue details] has many records regarding call that made contact to queue. With the [call details] table has info about each call. Purpose is to filter based on which queue call came from.

I don't have file i can actually supply. Fairly new to Power bi and trying to understand how nest I can do this.

 

[locka]

Is there anyone who can help with this issue Please?

 

[alansidman]

Without some data, the best I can offer is that you join your files in Power Query on the Primary Keys and Foreign Keys. You will have two joins to get all three tables into one query. If you wish to create three dummy files of 6-8 records and upload that data using XL2BB then I am sure we can supply you with specific Mcode to make this happen.