Countifs with Power Query

[Plukey]

=COUNTIFS(Mondays_Report[PLN Complete],"No",Mondays_Report[EBOM],"")

So, here's what i have for a formula that works with Excel, But, I'm trying to achieve a custom column with this formula using Power Query

 

[Plukey]

A custom column similar to this... If [EBOM] has a "No" then remove the "no" from [PLN Complete]

Im trying to count PLN Complete only if EBOM doesnt have a NO

 

[alansidman]

In a new column
= if [PLN Complete] = "No" then null else [PLN Complete]
Then delete the column PLN Complete and your new column replaces it.

You can then group by the new column and select Count as a function for the column

 

[Plukey]

In a new column
= if [PLN Complete] = "No" then null else [PLN Complete]
Then delete the column PLN Complete and your new column replaces it.

You can then group by the new column and select Count as a function for the column

Thanks, that's what I needed.

 

[alansidman]

Great! Thanks for the feedback.