Compensate working day hours

[Anonymous]

Hello people good night!

Please I have a question to make a report. I need a column that shows if a professional's hours were compensated in 2 business days.

In yellow is the expected result.

If the professional has worked overtime in one day, he has 2 consecutive working days to compensate for those hours. In other words, it is necessary that in the next 2 working days he checks if the employee's journey has been reduced, and if that extra amount has been deducted.

Attached I'm leaving an example with a PBIX exactly as the image, with the average of hours already performed, and with the bases. The Calendar table already contains the working days.

link with pbix and files : https://we.tl/t-kAmcHiPCBo 

Thanks for the personal support.

Spoiler

Spoiler

[lbendlin]

You have a typo in the second row for Carlos Alberto. Overtime is 00:20 and the flag should be No.

[Anonymous]

Hello friend, thank you for your help and for your time, I am very grateful. True, but I already made the correction, can you help me?
https://we.tl/t-qHv6PFRkb1 

[lbendlin]

Compare the sum of working hours to the sum of journey. If it is less or equal then the flag is yes else it is no.

Note that I converted all your duration strings back into day fractions. 8 hrs is 1/3 of a day.

[Anonymous]

You can attach an example of what you accomplished, but buddy it has to be working days. If the professional works overtime in a day, he has 2 working days to make up for those hours.