Counter variable in Power Query each loop

datasith · ‎Jun 13 2021

    /* [Index] and [Initial Stock] are columns in the Table that I can reference. */ 
    /* I'm curious how to have an "i" variable accessible in the M code */
    #"Added Index II" = Table.AddColumn(#"Added Index", "Index II",
        i = 0
        each if [Initial Stock] > 0 then 
            [Index]
            i = [Index]
        else 
            [i]
        ),

I'm new to power query. I understand having variables is *not* the way to do things. But. While I get a grasp on the language, can someone help me implement the pseudocode above? I want to have a running variable inside my "each" loop which gets updated depending on the condition. The hope is that the variable is created/modified from m-code, and not referenced from the data source. Again, sorry if this is not possible, I'm just getting started.

Sergei Baklan · ‎Jun 14 2021

@datasith

That will be easier if you explain what shall be in column Index II. If index in it for each zero Initial Stock shall be the same as for the previous non-zero, you may create column with

... each if [Initial Stock] > 0 then [Index] else null

and fill down after that.