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.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors