Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Consecutive Data

  This is a continuation of the thread below, which I'd already marked as solved, but have since noticed a problem: https://community.powerbi.com/t5/Desktop/Consecutive-Top-7-finishes-in-league-tab...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks for your response.

     

    Your formula didn't work, but I managed to figure out the problem. The column FinalIndex was of type "Text" where it needed to be numeric - as such the value 9 was taking precedence over the vlue 10 in this case.

     

    I have therefore stuck with the "Current" formula provided as a solution in the original post.

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Does this work in your scenario:

Current2 = 
MINX (
    TOPN (
        1,
        SUMMARIZE (
            'Results',
            Results[Player],
            Results[FinalIndex],
            "Counts", IF (
                LEFT ( MIN ( 'Results'[Result] ), 3 ) IN { "Low", "Fir" },
                 -COUNT ( Results[FinalIndex] ),
                COUNT ( Results[FinalIndex] )
            )
        ),
        [FinalIndex], ASC
    ),
    [Counts]
)

Regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for your response.

     

    Your formula didn't work, but I managed to figure out the problem. The column FinalIndex was of type "Text" where it needed to be numeric - as such the value 9 was taking precedence over the vlue 10 in this case.

     

    I have therefore stuck with the "Current" formula provided as a solution in the original post.