Forum Discussion

mmelerof's avatar
mmelerof
New Member
3 years ago

Extra Hours

Hi everybone,   Well, in my model, i have a column call "Horas Trabajas" it mean "Work Hours".   I want to know the extra hour my employments do, so if the work more than 160 hours per month, the...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi mmelerof 

please try

Horas Extras =
SUMX (
VALUES ( 'Enero 2023'[Empleado] ),
CALCULATE (
VAR Extras =
SUM ( 'Enero 2023'[Horas Trabajadas] ) - 160
RETURN
IF ( Extras > 0, Extras, 0 )
)
)