Forum Discussion
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...
Mahesh0016
Super User
Super User
This is the formula y used:
Horas Extras = CALCULATE( IF(SUM('Enero 2023'[Horas Trabajadas])> 160 , SUM('Enero 2023'[Horas Trabajadas]) - 160 , 0))
#My Solutions
#My Solutions
Horas Extras = calculate(SUM('Enero 2023'[Horas Trabajadas]) - calculate(SUM('Enero 2023'[Horas Trabajadas]),filter(Table,[Total Work Hours]>160)))
mmelerof If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.
mmelerof If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.