topic Write a query for index match in DAX Commands and Tips

Write a query for index match

Anonymous — Thu, 11 Aug 2022 12:38:52 GMT

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?

Re: Write a query for index match

tamerj1 — Thu, 11 Aug 2022 13:36:16 GMT

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

Re: Write a query for index match

Anonymous — Thu, 08 Sep 2022 02:24:57 GMT

Hi Anonymous

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.