Hi,

I have created a Data Model from a block of data.

The warehouse guys work from 17:00 to 04:00 daily, what's the best approach to obtain the units picked but displayed in one pivot table?

I can achieve this over 2 pivot tables using filters but ideally I want this in one table.

Each shift spans over 2 dates, 12am to 4am is the next date as they work past midnight (Sales Date Order)

Ideally I need a Dax Calculation column of a Dax measure to breakdown the Total Units, to filter 17:00-00:00 of one date and
Total Units, to filter 00:00 - 04:00am of the next date.

They can also work the following on the same shift at 17:00 so the pivot will pick up that unit data too if not filtered.

I'm after units picked per hour per shift, not spread over 2 shifts.

Can anyone help please? (I'm new to the Dax data model world)


I have attached links to jpg's of my data model.

Thanks


Pick 1.jpgPick 2.jpgPick 23.jpg