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...
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
)

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
)