Home Forums Power Pivot RANKX to only rank the first 3 months

Tagged: ,

This topic contains 2 replies, has 2 voices, and was last updated by  mfarr76 3 years, 2 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #2987

    mfarr76
    Participant
    • Started: 6
    • Replies: 6
    • Total: 12

    Hello,

    I have read through several post like this one but I still am unable to tackle this problem.

    I have several months of data that I would like to rank only the first 3 months. I can rank all the months using RANKX but when I try to filter it down to just the first three months I either get an error or the entire column is 1.

    The equation below is my latest attempt but it doesn’t work either.

    RANK_3MONTHS:=RANKX(FILTER(ALLSELECTED(P_DATA),P_DATA[TIME]<=3),[SUM MEASURMENT])

    Thanks in advance!

    Attachments:
    You must be logged in to view attached files.
    #2995

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2554
    • Total: 2561

    Maybe look at using TOPN before applying RANKX.

    Tom

    #2999

    mfarr76
    Participant
    • Started: 6
    • Replies: 6
    • Total: 12

    Thank Tom,

    I have been playing with TOPN but there isn’t all of helpful post of how to integrate this into the equation. Do you have any suggestions on this topic?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.