How to write a query on power bi

[namitajuneja15]

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?

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?

[namitajuneja15]

Thanks a lot guys, Your procedures really helped me tackle the situation

[BA_Pete · Accepted solution]

Hi @namitajuneja15 ,

I'd do this in Power Query rather than DAX:

You'll want to import both tables into PQ using 'Get Data'. We'll call the top one TableA and the bottom one TableB.

Once you have TableA open in PQ, select the [ID] column and go to the Transform tab > Unpivot Columns (dropdown) > Unpivot Other Columns.

Now you can go to the Home tab > Merge Queries and merge on TableA[Attribute] = TableB[Index].

Pete