Create a costum column which counts consecutive negative numbers

Hi Pete230 

First, add an index column in power query.

Then use the following code to add a custom column:

let
CurrentRow = [Index],
ListNegative = List.LastN(
                List.FirstN(Source[B], CurrentRow+1),
                each Number.FromText(_) < 0
            )
in 
List.Count(ListNegative)

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.