very urgent help needed

[asif082]

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]

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.

[asif082]

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

[Baskar]

@asif082

Did you tried the Groupby function with ProdID.

Can you please share some sample table here. 

[asif082]

here is the pbix file.

https://drive.google.com/open?id=1n-7MocSobf2XsUT5ImT2J58aHpzB4cph

[Baskar]

[asif082]

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 · Accepted solution]

@asif082

Groupby is the solution in Power Query

[asif082]

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]

duplicate the table and group by. 

If possible share the image of your report relationship 

[asif082]

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.

[Baskar]

@asif082 Try this 

[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.

[asif082]

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.

[asif082]

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.

[Ashish_Mathur]

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.

[asif082]

here is the file link

https://drive.google.com/open?id=1vSLW5zG-VnKetHEVP9bEO9PWsQcU5PHh

thanks

[Ashish_Mathur]

Hi,

You may download my solution workbook from here.

Hope this helps.