Forum Discussion
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...
Anonymous indeed, there are some misconderation and i have updated the reply. see if it is torwards the target.
Hey FreemanZ
Looks like I was wrong about the CALCULATE() bit. Seems to be working fine!
Thanks a lot
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: