Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
Solved! Go to Solution.
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
Proud to be a Datanaut!
Thanks a lot guys, Your procedures really helped me tackle the situation
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
Proud to be a Datanaut!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
8 | |
7 | |
6 |