Running count that resets

[ThornTech]

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	2
Win	1
Win	2

The Trade UID is the main index for this table that is unique.

Any guidance on how to do this would be great, I've tried quite a few different things and the closest I can get it to create a running count, but can't get it to reset.

A sample of the dataset can be found here: https://1drv.ms/u/s!Ag_sNauqdCgpg95oGmGBlk9NJrf0Uw?e=hICHI1 

Thanks

[ThornTech]

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

[CNENFRNL · Accepted solution]

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