How to sum with if condition in Power Query Editor

[BishwaR]

I want to sum a column in Power Editor with IF condition.

Something like below:

= List.Sum(Cost) if Month = "November"

Please help Thanks

[BishwaR]

If the condition is false then null

[KNP]

Try this:

if [Month] = "November" then List.Sum({[Cost]}) else null

I assumed you're doing this by adding a custom column.

Edit: was missing some brackets.

[BishwaR]

Thank you so much

[KNP · Accepted solution]

What do you want to happen if it doesn't equal your value?

Please provide some data and your desired outcome.