Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create sumif in PowerQuery (not DAX, and not use group by feature)

I have a step in PowerQuery where I want to do a sumif (like in Excel). See the below picture.   In Power Query I have Field 1 and Field 2 and I want to add what is in column C.  Column C sums colu...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Try this code for a custom column:

     

     

    let _item = [Column1] in
    List.Sum(
    Table.SelectRows(#"Changed Type", each [Column1] = _item)[Column2])

     

     

     

    Change the bold part for the last step name.

Dave_Clark's avatar
Dave_Clark
New Member
6 years ago

Your example worked well, even with a self-reference for the criterion. How would you do this for two or more criteria?

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Dave_Clark ,

 

You can use more conditions with variables, like:

 

let

_item = [Column1],

_item2 = [ColumnXXX]

in
List.Sum(
Table.SelectRows(#"Changed Type", each [Column1] = _item and [ColumnXXX] = _item2 )[Column2])