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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
k123
Frequent Visitor

How to merge a grouped table with another table?

Hi I am new to Power BI,

 

I am trying to merge my grouped table that I created by grouping on various columns of my original data and now I want to merge this table with another unrelated table. Once I created this grouped table I also created a relationship with my original data in the model.

 

Grouped table:

ID  Student_name Exam_desc                   Exam    Grades

1    Abc                  Class 12  advanced biology     Bio     A

2    Xyz                   Class 2 math           math         Math B

 

Other table that I want to merge with is as follows:

Exam_id   Exam_desc

123          Class 10 math

312          Class 2 math

.......................

 

Please let me know how to implement this. Thanks!

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @k123,


You can add a calculate column to grouped table with lookupvalue function to find out correspond records from other table.

Exam_id =
LOOKUPVALUE ( Table2[Exam_id], Table2[Exam_desc], Groupped[Exam_desc] )

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

HI @k123,


You can add a calculate column to grouped table with lookupvalue function to find out correspond records from other table.

Exam_id =
LOOKUPVALUE ( Table2[Exam_id], Table2[Exam_desc], Groupped[Exam_desc] )

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.