Forum Discussion
Countifs with multiple conditions in PowerQuery in PB
Hello Wonderful people An example of the countifs formula with multiple conditions I am currently using in Excel is given below. I wish to replicate the same formula in PowerQuery in PB: =COU...
Hi Anonymous ,
This is my test data.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
You can use the following SQL statements.
select count(*)
from table
where date >= '2020-01-01' and date <= '2022-11-18' and column <> '24 Application withdrawn'
You also can refer to the following posts that may be helpful to you:
SQL Countif function - Stack Overflow
sql - How to do countIf() in Oracle - Stack Overflow
COUNTIF in SQL: COUNT(CASE WHEN … THEN 1 END) (modern-sql.com)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.