Forum Discussion
How to write a query on power bi
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?
Hi Anonymous ,
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
2 Replies
Hi Anonymous ,
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