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.
Hey 🙂
I have a table of production order ID's, coil ID's, and date of completed production. I want to make a new column that within each PO ranks the coils in the order they were produced. I think I'm supposed to use the RANKX-function, but I'm not sure how to apply filters.
production_order | Coil | First complete date |
127 | 426 | 26.08.2018 14:24 |
970 | 900 | 25.06.2018 03:37 |
970 | 911 | 25.06.2018 04:57 |
970 | 152 | 01.09.2018 15:41 |
969 | 523 | 10.09.2018 04:10 |
969 | 525 | 10.09.2018 04:36 |
740 | 373 | 29.09.2018 19:49 |
740 | 386 | 29.09.2018 21:26 |
740 | 387 | 29.09.2018 23:04 |
Here, I'm trying to make a new column that gives coil 900 rank 1, coil 911 rank 2, and coil 152 rank 3, and then starts over from rank 1 on the next PO.
Solved! Go to Solution.
Try this calculated column
Column = RANKX ( FILTER ( Table1, [production_order] = EARLIER ( [production_order] ) ), [First complete date], , ASC, DENSE )
Try this calculated column
Column = RANKX ( FILTER ( Table1, [production_order] = EARLIER ( [production_order] ) ), [First complete date], , ASC, DENSE )
That worked. Thanks a lot! I've been sitting for hours trying to figure this out 🙂
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |