Match two tables on two columns and populate new column with slicer value (non related field)

[Anonymous]

I have two tables ('Assets' and 'YrIncrements') example below:

I have a slicer based on (YrIncrements['Yrs']). I would like to know if its possible to join the two tables on ['Service'] and ['Range'] and populate the slicer value in a new column within the Assets table.

In the Assets table there will be duplicated Service and Range pairs but unique rows due to Age_Yr value. 

Thanks in advance.

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Does this your expected result?

If it is, here's my solution.

Select Assets table, then click Merge Queries tab under Home ribbon.

Select Service and Range column at the same time in two tables, select left outer in Join Kind.

Select the expand button, then select Yrs column.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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

[Greg_Deckler]

@Anonymous Might not be understanding, but seems like you could use a Merge step in your Assets query? Maybe create a combo key column, [Service] & "_" & [Range]?