locked
rank in power pivot RRS feed

  • Question

  • Hello. I have STATE, VALUE and YEAR as columns. How can I rank each state for it's position by year (compared to other states)? Thanks. 
    Tuesday, December 20, 2016 6:37 PM

Answers

  • Hi AlexMartini,

    Based on my understanding, the state column values are text which is not able to rank. So you want to rank the state by value in each year, right? If it is, please review the solution as follows.

    The following screenshot is my sample data.



    Create a calculated column to rank, and get the desired result as the snapshot below.

    =RANKX(FILTER(Table3,Table3[Year]=EARLIER(Table3[Year])),Table3[Value])


    If this is what you want, please share us sample data for analysis.


    Best Regards,
    Angelia


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, December 21, 2016 1:49 AM