Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 break down the quantity built into these shifts so we can see productiuvity. How would I go about doing so?
Thanks
Craig
Solved! Go to Solution.
@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")
Hi @CraigBlackman. I would just derive custom column from this datetime column and mark rows which have datetime 7am to 7pm as "ShiftA" and the rest as "ShiftB". Then you can filter by this column, or create measure where you have filter on just ShiftA´s data.
Regards.
Pavel
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |