Forum Discussion

AppleMan's avatar
AppleMan
Helper III
2 years ago
Solved

Overtime Report Help

Hi,   I need some help designing the best way to make an overtime report work.   Right now, I have a table that has every labor entry employees have made. The important columns are: Employee num...
Need Help
  • rsbin's avatar
    rsbin
    2 years ago

    AppleMan ,

    Various ways this can be done.  I have attached an updated pbix that shows one of these ways.

    Import your Holiday Table.  Connect it to your Date Table.  It should be 1-1 relationship.

    Then I created a Calculated Column in your Date Table using SWITCH and LOOKUPVALUE.

    I structured it to give you 0's and 1's, but you can replace these with other values if you so choose ("Holiday" or "Work Day").

    Let me know if you run into any issues....

    Regards and Good Luck

rsbin's avatar
rsbin
Community Champion
2 years ago

AppleMan ,

You don't need to incorporate this into your Measure above.
Just create a simple measure called WeekendOT = SUM( YourOTTable[OTHours] ).

Your first measure is WeekdayOT.

Then for Overtime_Total = [WeekdayOT] + Weekend[OT]

The idea behind creating the calculated table was to avoid messing with your Variables.

Hope I have explained this properly.

AppleMan's avatar
AppleMan
Helper III
2 years ago

Yeah thats how I ended up doing it. Have a few more kinks to work out to get this working properly with a holiday schedule table I have to change the overtime threshhold, but all in all its coming together well.