Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Everyone,
I have 3 tables which producing below result.
Current Outcome
Desire Result
what I need is I want to merge duplicate ID in two one row where it shows Full Time and Part Time in one row.
If any one knows how can I achive this please
Hi @asif082,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @asif082,
On your Current Outcome do a grouping by then add all your columns to the Goup by option and on the Part Time select the option MAX.
This should give expected result.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi,
Thanks for the reply, but the problem is all the names come from Employee Table.
so I have these 4 tables, Position, engagement, Grades and Employee
Enagement is where all the data is link via ID's from those three table.
so the screen shot I have sent earlier is actually a Table visualization in power BI and when I go in edit quries mode how I group by from different tables?
Thanks
Hi @asif082,
From your description, you could also follow the MFelix 's function to group your data by [ID] due to your row data table have no [Name] column, if it still could not solve your problem, could you please offer some sample data to have a test?
Regards,
Daniel He
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |