RANKX Help

[Anonymous]

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.

 

[amitchandak · Accepted solution]

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
)