Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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....
Solved! Go to Solution.
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.
Thanks Ashih for the reply but the solution you proposed is not working, removing duplicates removed the correct row too. see below
Did you tried the Groupby function with ProdID.
Can you please share some sample table here.
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?
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.
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.
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.
Hi,
Share the link from where i can download your Excel file.
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.
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.
Hi,
You may download my solution workbook from here.
Hope this helps.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
105 | |
105 | |
88 | |
61 |
User | Count |
---|---|
165 | |
133 | |
132 | |
95 | |
86 |