Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
Show and Tell
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    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

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

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