Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    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]))
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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