Forum Discussion
Min and max values
Hi,
Could someone please help me with a DAX formula MIN and MAX.
I have a table:
| Order no. | Operation | Time |
| Order 1 | Picking | 01:15:00 |
| Order 1 | Moving | 01:25:00 |
| Order 2 | Picking | 02:30:00 |
| Order 2 | Picking | 02:45:00 |
| Order 3 | Picking | 12:30:00 |
| Order 3 | Picking | 12:40:00 |
| Order 3 | Picking | 12:50:00 |
| Order 3 | Sending | 13:55:00 |
And i need to know the min and max time values by order number and by operation type (can concatenate).
As a result a would like to know when a picking operation for a specific order was started and when in ended.
Whank you in advance! :)
No RepliesBe the first to reply