Forum Discussion

AndyDD_UK's avatar
AndyDD_UK
Helper III
3 years ago

Help with DAX for missing hours

In table A I have number hours entered by employee, day and activity. Example of table:

 

Employee_id / DateofActivity / Activity (project id) / Hours Spent on Activity / Datetime entered onto timesheet system

 

In table B I have hours expected to work by week by employee_id, example of table:

Employee_id / Standard_hours

123                  40

 

In my Cube I have a measure called 'missinghours_overtime' which is = sum(TableA[HoursSpentActivity]) - sum(TableB[Standard_hours])

 

In Power BI report I can show missinghours_overtime' by employee by week and as a total.

 

Example:

Employee123 shows 10 hours overtime in week 1 and 20 hours missing for week 2, making a total of 10 missing hours.

 

How can I only focus on missing hours, ie have the report show 0 missing hours in week 1 and 20 missing hours in week 2 making a total of 20 missing hours ?

3 Replies