Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've read many posts for similar questions, but none apply to my scenario...
I have an Employee Table and a Project Team table that are connected by the Employee ID number.
I want to show how many projects each employee has been on, by counting the number of times each ID appears in the table.
Here is a mock-up of my Project Team table:
Here is what my outpout would look like:
Thanks in advance.
Solved! Go to Solution.
Hi @Rob_BTG ,
Believe that the fastest wau would be to unpivot your Project Team Table and stay with only 3 columns Project ID, Team Member, Employee ID then just make a simple count of the number of ID.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Rob_BTG ,
Believe that the fastest wau would be to unpivot your Project Team Table and stay with only 3 columns Project ID, Team Member, Employee ID then just make a simple count of the number of ID.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMFelix,
Thanks, that would be the simplest way. I was making it harder than it needed to be.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |