Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Creating Calculated Table with Shift Hours

Hi all,   I have a dataset that looks like the one below. (Below is a sample of my real data): As you can see, for every unique employee and date combination, we have four sets of times. Shi...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    Anonymous  indeed, there are some misconderation and i have updated the reply. see if it is torwards the target. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi FreemanZ ,

 

I am trying the SUMMARIZE() approach but i think you misunderstood the shift hours thing. I think your logic prints the difference between the largest and smallest times in the entire dataset.

My shift hours logic is Shift End minus Shift Start minus 30 mins, where Shift Start and Shift End are times for each employee for that particular day. (see sample data I posted above).

 

Kind regards,

Midhun

FreemanZ's avatar
FreemanZ
Super User
3 years ago

Anonymous  indeed, there are some misconderation and i have updated the reply. see if it is torwards the target. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hey FreemanZ 

     

    Looks like I was wrong about the CALCULATE() bit. Seems to be working fine!

    Thanks a lot

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      Anonymous if you feel more comfortable with measure + visual, you may also plot a table visual with a measure like this:

      ShiftHours = MAX(TableName[Time])- MIN(TableName[Time])-1/48
       
      i tried and it worked like this: