Forum Discussion
Minimal value by specific column
Hi,
I have a problem solving a problem:
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 |
I need to get the minimum and maximum time values by order and by operation (can concatenate).
Egz.: Min for Order 3 by Operation Picking is 12:30 and Max is 12:50.
Don`t really know what DAX formula tu use for that kind of column.
Need assistance, thank you in advance :)
No RepliesBe the first to reply