Write a query for index match

[namitajuneja15]

Hello Team,

I am new to POWER BI  and for creating a dashboard I need to join these 2 tables based on index .

How do I write a DAX query to join the index of 2nd table to the column name of 1st in POWER BI. Is there any other way to do so?

[v-yetao1-msft · Accepted solution]

Hi @namitajuneja15 

Select the value "S_0_1" , "S_1_0" .. "S_1_4" , then unpivot the selected columns .

Then go back to report view , you can match with index column .

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tamerj1]

Hi @namitajuneja15 
You need first to unpivot the first table using power query.