Forum Discussion
Solved
Calculate quantity built based on 2 x 12 hour shift pattern
Hi, I have a table that provides me with a quantity build and the date/time that item was built. We are moving to a 2 x 12 hour shift pattern runny 7am to 7pm and then 7pm to 7am. I want to b...
CraigBlackman Use below DAX to create calculated column to group into shiftA and shiftB and then filter.
Column = IF(AND(HOUR('tableName'[datetimeColumn]) >= 7,HOUR('tableName'[datetimeColumn]) <= 19), "shiftA", "shiftB")
CraigBlackman Use below DAX to create calculated column to group into shiftA and shiftB and then filter.
Column = IF(AND(HOUR('tableName'[datetimeColumn]) >= 7,HOUR('tableName'[datetimeColumn]) <= 19), "shiftA", "shiftB")
ankitpatira, works a charm, was over looking a simple solution.