Employee Overtime: A Real-World Data Analysis Tutorial in Power BI | HR Analysis | MiTutorials

[@sr5726]

Thank you !
No Of Employees =
VAR emp_OT =
ADDCOLUMNS(
SUMMARIZE( Overtime, Overtime[EmployeeID]),
"@Overtime Days" , [Overtime Days]
)
RETURN
CALCULATE(
DISTINCTCOUNT(Overtime[EmployeeID]),
FILTER(
emp_OT,
[@Overtime Days]=MAX('Xaxis OvertimeDays'[Days])
)
)

[@nariroeplal1553]

U were right, is indeed a bit complex 😢😅 but well explained. Thanks!

[@MITutorials]

Glad you found it useful 😊

[@nkechiizeji]

This is too complex. Don't really understand.