SUM IFS in Power Query using a date and article number without Group By

[Anonymous]

Dear all,

I'd like to perform a SUM IFS in Power Query to calculate the running stock total of an article code based on date and article number. I've used the following code and I tried to add an extra variable. This doesn't work. Does someone know what I have to change in order to fix it.

Desired result (formula Excel)Power Query

Many thanks in advance.

[Greg_Deckler · Accepted solution]

@Anonymous Try: 

Table.AddColumn(#"Changed Type", "Custom", each let __item = [Article Number], __order = [Order Date] in List.Sum(Table.SelectRows(#"Changed Type", each [Article Number] = __item and [Order Date] <= __order)[Mutation]))

[Anonymous]

Hi @Greg_Deckler, this works great! Thanks (again) for your help. Much appreciated!