Forum Discussion

ThornTech's avatar
ThornTech
Frequent Visitor
4 years ago
Solved

Running count that resets

Hi,   I have a data set where I want to count the number of Loss or wins in a row, but reset each time it switches to the new name like this: Win 1 Win 2 Win 3 Loss 1 Loss...
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago

     

    PQ and Excel formula are way much conciser and more straightforward,

    Grouped = Table.RemoveColumns(Table.Group(Source, "PnL Text", {"ar", each Table.AddIndexColumn(_, "Streak_PQ", 1)}, 0), "PnL Text")

     

ThornTech's avatar
ThornTech
Frequent Visitor
4 years ago

This worked a treat, I used the PQ version in the end. Thanks for quick help.