Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
namitajuneja15
Frequent Visitor

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?

namitajuneja15_0-1660221626750.png

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?

 

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
namitajuneja15
Frequent Visitor

Thanks a lot guys, Your procedures really helped me tackle the situation

BA_Pete
Super User
Super User

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors