Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hedonistclam
New Member

Using RANKX to determine production sequence

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_orderCoilFirst complete date
12742626.08.2018 14:24
97090025.06.2018 03:37
97091125.06.2018 04:57
97015201.09.2018 15:41
96952310.09.2018 04:10
96952510.09.2018 04:36
74037329.09.2018 19:49
74038629.09.2018 21:26
74038729.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.

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@hedonistclam

 

Try this calculated column

 

Column =
RANKX (
    FILTER ( Table1, [production_order] = EARLIER ( [production_order] ) ),
    [First complete date],
    ,
    ASC,
    DENSE
)

Regards
Zubair

Please try my custom visuals

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

@hedonistclam

 

Try this calculated column

 

Column =
RANKX (
    FILTER ( Table1, [production_order] = EARLIER ( [production_order] ) ),
    [First complete date],
    ,
    ASC,
    DENSE
)

Regards
Zubair

Please try my custom visuals

That worked. Thanks a lot! I've been sitting for hours trying to figure this out 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.