Forum Discussion
Solved
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....
Ashish_Mathur
Super User
Super UserHi,
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.
Thanks Ashih for the reply but the solution you proposed is not working, removing duplicates removed the correct row too. see below
- Ashish_Mathur
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.
okay here is the link
https://drive.google.com/open?id=1n-7MocSobf2XsUT5ImT2J58aHpzB4cph
Thanks alot.
- Ashish_Mathur
Hi,
Share the link from where i can download your Excel file.
- Baskar
Resident Rockstar
Did you tried the Groupby function with ProdID.
Can you please share some sample table here.