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 ,

Yes please close this thread.  Continue to poke away.  You caught me at a good time, because I have just published an Employee Time Report for my company.
Best Regards,

AppleMan's avatar
AppleMan
Helper III
2 years ago

I will for sure let you know if I run into any further questions! I should have the data manipulated how I want from here, just need to make sure my measures function how I expect as I get the visuals thrown together. 

Again, appreciate the help!