cancel
Showing results for 
Search instead for 
Did you mean: 
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

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Using RANKX to determine production sequence

@hedonistclam

 

Try this calculated column

 

Column =
RANKX (
    FILTER ( Table1, [production_order] = EARLIER ( [production_order] ) ),
    [First complete date],
    ,
    ASC,
    DENSE
)
Try my new Power BI game Cross the River

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Using RANKX to determine production sequence

@hedonistclam

 

Try this calculated column

 

Column =
RANKX (
    FILTER ( Table1, [production_order] = EARLIER ( [production_order] ) ),
    [First complete date],
    ,
    ASC,
    DENSE
)
Try my new Power BI game Cross the River

View solution in original post

hedonistclam
New Member

Re: Using RANKX to determine production sequence

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors