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.
Task Name | Task Start | Task End | Student | Student Start Date | Student End Date |
Task 1 | 1/1/2017 | Null | Student 1 | 1/1/2017 | 4/1/2017 |
Task 1 | 1/1/2017 | Null | Student 2 | 4/2/2017 | 4/5/2017 |
Task 1 | 1/1/2017 | Null | Student 1 | 4/6/2017 | 12/1/2017 |
Task 1 | 1/1/2017 | Null | Student 3 | 12/2/2017 | 12/31/2017 |
Task 2 | 1/5/2017 | Null | Student 3 | 1/1/2017 | 12/31/2017 |
Task 2 | 1/6/2017 | Null | Student 1 | 7/1/2017 | 12/31/2017 |
Task 3 | 1/7/2017 | Null | Student 2 | 3/1/2017 | 7/1/2017 |
I have a sample dataset like this. In such case, I need to find what will be the load% or efficiency% of each student. How can I determine this using DAX? I tried to calculate days worked by taken the difference of days and distinct tasks. But i end up creating 4-5 measures. Any suggestions?
Also, how do I filter this by Year and Month that efficiency comes until that date? Example - If i choose from Jan 2017 to Aug 2017, it must display efficiency until Aug 2017.
Hi,
How do you calculate Load% or Efficiency %? Show the expected result.
It's basically calculating average number of tasks done by a student when he is working. This shall also get filtered by any date that I choose in the slicer.
Can you please show the expeceted result in a pic with intended formula
Could you please show the output with the formula?
OK, so COUNT of Tasks is you numerator it sounds like, what is your denominator? Since this is a %. Is it the COUNT of all tasks (regardless of student), the number of days the student is working?
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |