Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 @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
Proud to be a Datanaut!
Thanks a lot guys, Your procedures really helped me tackle the situation
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.