M code and DAX running total

[dicken]

Hello,
pretty new to power query and dax, I've used < List.Sum list.firstN / Range and List.Accumulate to create running totals, and an index column in Dax power pivot
but I'd like to create one based on a condition, so at simples two columns 'Product ' a b c and 'sales' and create a running total of sales based on the product ;
so in Excel < sumif ( product range, 1st cell of product range (ie ($A$1:A1),range to sum >

 

[JGordon11]

this might help

 

[dicken]

this might help

Hi again,

Thanks, I'll watch it ; funny enough I've just worked through Mike Girvin (excel fun) Magic trick 1553 where Table.Buffer is used in creating a running total using Tablle.SelectRows.

RD