Forum Discussion
Efficiency calculation
| 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.
5 Replies
Hi,
How do you calculate Load% or Efficiency %? Show the expected result.
Can you please show the expeceted result in a pic with intended formula
