Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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! 🙂
User | Count |
---|---|
15 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
29 | |
17 | |
11 | |
7 | |
5 |