Forum Discussion

Copper Contributor

Jul 26, 2021

Count if formula for multiple columns in power query

How to write a formula =countif(A2:M2,"<=15") in power query?

Copper Contributor

Mar 12, 2023

I came to the point of "checkIfInWindow" by clicking :).
Then row multiplied - I considered it a mistake.

So after grouping by max(IsIn) stay 1 (true), it seems to work.

Thanks

Diamond Contributor

Mar 13, 2023

Didn't catch which exactly mistake did you have. However, good to know if it works finally.