Lookupvalue and min

[Greg]

Hi @pedroccamara. Check out the POTW #3 thread … very similar problem and many different approaches to solutions.
Greg

Problem of the Week #3 (DAX) - Timesheet and Wages

[POTW 3 - Page 1 Screenshot] OK, here we go! Problem of the Week #3 is now live! For background on this initiative, check out this post and this week’s launch video that Brian and I did on YouTube. Background on this week’s problem Timesheet data is common to many organizations, and the associated wage costs often are subject to certain rules. Employees are often paid wages based on how many and when hours are worked, and in this exercise, employees are paid as follows: Normal hours (up …