DAX function - Index and match

[9036273024]

Dear friends, 

I have Two tables with columns respectively.

1. Doctor name and service names (Column  names respectively) 

2. Matrix Table -

Doctor name - in column

Service name in first row. (Doctor payment for each doctor differs for every service so used matrix table for the same) 

I want use matrix table and pull payout of each doctor service wise.  (In excel I use index and match formulae to pull that information) 

Please help to fill doc pay column

[ChiragGarg2512 · Accepted solution]

@9036273024 , For second table when uploaded to powerBI will convert the first row that contains service names to column headers. So there will be two tables in PowerBI 

1. Table with doctor name and services they provide two columns.

2. With doctor name and columns with header name being services[s1, s2, s3, etc. being columns].

To change the second from happening, go to powerQuery[transform data] and select every column except doctor name and unpivot the table.

Now, in matrix visual rows can be doctors name, columns can be the new column that contains every service and values can be price.

This will create a matrix visual of a doctor and service name.

Thank You.