Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculate Hours Worked Per Week For Each Employee ID

I am very new to Power BI and cannot figure out the DAX to solve my problem. I have a table of data in Power BI that looks like the following table: Site EmployeeID Name Date Clocked Presence...
  • gmsamborn's avatar
    gmsamborn
    2 years ago

    Hi Anonymous 

     

    Would a measure like this help?

    Total by Emp and Week = 
    CALCULATE(
        SUM( 'Table'[Clocked Presence] ),
        ALLEXCEPT( 'Table', 'Table'[EmployeeID], 'Table'[Week] )
    )

     

    Let me know if you have any questions.

     

    Total by Emp and Week.pbix

     

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 

 

Would a measure like this help?

Total by Emp and Week = 
    CALCULATE(
        SUM( 'Table'[Clocked Presence] ),
        ALLEXCEPT( 'Table', 'Table'[EmployeeID], 'Table'[Week] )
    )

 

Let me know if you have any questions.

 

Total by Emp and Week.pbix

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Awesome that worked like a charm, I accepted it as the solution.