Forum Discussion
thmonte
6 years agoHelper IV
Shaping Date Using a Shift Offset?
I am working with employee pay records and I have employees where their shift overlaps days. For example: I am scheduled to work Thursday 3/19 but I come in at 6PM Wednesday and work till 6AM Th...
edhans
6 years agoCommunity Champion
I'm not understanding the problem well enough. If you want all of those records in your sample data to be returned if you select Feb 11, then just use the End Date column for your slicer. If that won't work, explain why and how you'd logically determine what should be pulled, then we can assist with measures, calculated columns, or Power Query logic to assist in getting what you need.