Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

power query column sum in if statement

I am trying to use the following code for a custom colum to find the summation of values in the "Custom" column that also have "B" and "Knowledge in the row. Why is this not working?

 

if [Column] = "B" and [Bucket] = "Knowledge" then List.Sum([Custom]) else "null"

 

dero_0-1655406857624.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

RicoZhou_0-1655798013151.png

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.

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

RicoZhou_0-1655798013151.png

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.

 

Hariharan_R
Solution Sage
Solution Sage

Hi

Your column [Custom] is a list? You can use List.sum if you are referring a list.

Thanks

Hari

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.