Forum Discussion

hixkim's avatar
hixkim
Frequent Visitor
4 years ago
Solved

Rank based on multiple fields

Hello - hoping someone is able to help me out with this, I'm a little out of my depth. I think either a column or DAX would work for me.  Ultimately I want to rank a vendor's weekly pricing lowest t...
Need Help
  • themistoklis's avatar
    themistoklis
    4 years ago

    Hello hixkim 

     

    Create a new calculated column with the following formula:

    Sorting Column = 
RANKX (
    FILTER ( 'Table', 'Table'[Year-Week] = EARLIER ( 'Table'[Year-Week] ) && 'Table'[Item Number] = EARLIER ( 'Table'[Item Number] ) ),
    'Table'[Unit Cost],
    ,
    ASC,
    DENSE
)

     

    Workspace Attached

themistoklis's avatar
themistoklis
Community Champion
4 years ago

Hello hixkim 

 

Create a new calculated column with the following formula:

Sorting Column = 
RANKX (
    FILTER ( 'Table', 'Table'[Year-Week] = EARLIER ( 'Table'[Year-Week] ) && 'Table'[Item Number] = EARLIER ( 'Table'[Item Number] ) ),
    'Table'[Unit Cost],
    ,
    ASC,
    DENSE
)

 

Workspace Attached

hixkim's avatar
hixkim
Frequent Visitor
4 years ago

You're amazing. Thank you!!