Forum Discussion

sunil3M's avatar
sunil3M
New Member
5 years ago
Solved

cummulative sum

hi   how to create below calculation in Power in a new column.     Orderd qty =SUMIF($A$2:A2,A2,$B$2:B47)   SKU is column A , BACK QTY is column B and ordered qty is the result qty as pe...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi sunil3M ,

     

    Try the following formual:

    Order qty1 = 
SUMX (
    FILTER (
        'Table',
        [SKU #] = EARLIER ( [SKU #] )
            && [Index] <= EARLIER ( [Index] )
    ),
    [BACK QTY]
)


    Best Regards,
    Henry


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

     

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi sunil3M ,

 

Try the following formual:

Order qty1 = 
SUMX (
    FILTER (
        'Table',
        [SKU #] = EARLIER ( [SKU #] )
            && [Index] <= EARLIER ( [Index] )
    ),
    [BACK QTY]
)


Best Regards,
Henry


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