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
asif082
Frequent Visitor

very urgent help needed

I needed some help with Power BI I need to merge or group by Position ID. Please see below image.

 

Please help with this, thanks alot....

 

Data.PNG

1 ACCEPTED SOLUTION
Baskar
Resident Rockstar
Resident Rockstar

@asif082

Groupby is the solution in Power Query

View solution in original post

18 REPLIES 18
Ashish_Mathur
Super User
Super User

Hi,

 

In the Query Editor, click on the 5th column and go to Transform > Fill > Down.  Now select the first 4 columns, right click > Remove Duplicates.

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thanks Ashih for the reply but the solution you proposed is not working, removing duplicates removed the correct row too.  see below 

 

Data1.PNG

 

 

Baskar
Resident Rockstar
Resident Rockstar

@asif082

 

Did you tried the Groupby function with ProdID.

 

 

Can you please share some sample table here. 

 

 

Baskar
Resident Rockstar
Resident Rockstar

Group BY1.PNG

okay yeah this worked thanks alot. The real data is coming from big table so I belive all I need is to use related or some dax function to extract data from master table and use group by on this new table right?

Baskar
Resident Rockstar
Resident Rockstar

@asif082

Groupby is the solution in Power Query

Hi Basker do you know how can I group by without affecting the master table. If I group by that table it will going to impact on other reports. 

 

Thanks one again.

Baskar
Resident Rockstar
Resident Rockstar

duplicate the table and group by. 

If possible share the image of your report relationship 

This solution is not working actually. 

 

The issue is when I apply group by to duplicate table the calculated Columns which fecting data from other table disappear. 

 

Here is relatioship diagram.

Capture.PNG

 

 

 

 

Baskar
Resident Rockstar
Resident Rockstar

@asif082 Try this 

Group BY.PNG

Hi,

 

You have to select the first 4 columns and then right click > Remove Duplicates.  If it still does not help, then share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi,

 

Share the link from where i can download your Excel file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi Ashish,

 

I can't share a link as the data is connected to login based so you won't see thing any other suggestion?

 

But data is coming from 3 tables and the relationship diagram I have shared. And in engaments Substantive and acting details come.

 

Position Title and Postion type comes from position List

Position ID and Acting date comes from Engagements List

Grades from grades List

Substantive Full Name and Acting Full name comes from Employee List.Data.PNG

 

 

 

 

Hi,

 

Type the 16 rows of data which i see in your post into an Excel file and then share the link from where i can download your Excel file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi,

 

You may download my solution workbook from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.