Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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!
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |