power query column sum in if statement

Hi Anonymous ,

I think you need to add a list into List.Sum() function. Try this code.

if 
[Column] = "B" and [Bucket] = "Knowledge" 
then 
List.Sum(
Table.SelectRows(#"Changed Type", each ([Column] = "B" and [Bucket] = "Knowledge"))[Custom]
)
else
null

Result is as below.

If you only want to get sum total based on [Column] = "B" and [Bucket] = "Knowledge" in the whole new column.

I think you don't need IF() function.

List.Sum(
Table.SelectRows(#"Changed Type", each ([Column] = "B" and [Bucket] = "Knowledge"))[Custom]
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.