Forum Discussion
SUM IFS in Power Query using a date and article number without Group By
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.
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]))
2 Replies
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]))Hi Greg_Deckler, this works great! Thanks (again) for your help. Much appreciated!