The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
14 | |
12 | |
8 | |
6 | |
5 |
User | Count |
---|---|
29 | |
18 | |
13 | |
8 | |
5 |