topic Re: Running count that resets in DAX Commands and Tips

Running count that resets

ThornTech — Sun, 10 Oct 2021 15:32:35 GMT

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

Re: Running count that resets

CNENFRNL — Sun, 10 Oct 2021 18:06:52 GMT

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

Re: Running count that resets

ThornTech — Mon, 11 Oct 2021 08:59:21 GMT

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