Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RANKX Help

I'm trying to us the RANKX formula to rank store numbers based on their Potential ACV. 

 

I have the Store/Outlet Number, and Potential ACV columns in the table. 

 

This is the formula I'm trying to use:

ACVRank = CALCULATE(RANKX(ALL('Walmart Data'[Store/Outlet Number],'Walmart Data'[Potential ACV],
 
But when I try to use the comma to go to the "value" or "order" part of the formula, it never lets me get to that point. It just keeps giving me the option to add more columns into the formula. I'm sure it's something I'm doing wrong, but I can't figure it out. 
 
Photo attached shows the columns in the data.
 
 
 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Please close all. I think parenthesis is missing 

    In case you need more than one column

    Column =
RANKX (
    'Table',
    RIGHT ( 'Table'[Period], 4 ) & LEFT ( 'Table'[Period], 2 ),
    ,
    DESC,
    DENSE
)

     

     

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Please close all. I think parenthesis is missing 

    In case you need more than one column

    Column =
RANKX (
    'Table',
    RIGHT ( 'Table'[Period], 4 ) & LEFT ( 'Table'[Period], 2 ),
    ,
    DESC,
    DENSE
)