Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
I'm trying to
get the output below,I've tried pivoting,groupby and summarize but haven't gotten the desired output.
Input | ||
Project ID | Manager | Coordinator |
P1 | John | Chris |
P2 | Chris | Chris |
P3 | Kam | John |
Output | ||
Name | Project Count | Reference Details |
John | 2 | (P1,P3) |
Chris | 2 | (P1,P2) |
Kam | 1 | (P3) |
Solved! Go to Solution.
You will need to convert the values in rows into comma separated values.
Here is a table showing the output needed
Hi
I was not able to make sense of the Reference logic.
Plus, could you show me how you want it to be used in a Visual, or after you have this information, what all you want to do with it in the calculation?
Instead of consolidating it, it would probably be best if you could get it more expansive in terms of row count.
I'm new to power bi,just trying to solve a challenge
You will need to convert the values in rows into comma separated values.