Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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. 

     

     

Bifinity_75's avatar
Bifinity_75
Icon for Solution Sage rankSolution Sage
3 years ago

Hi Anonymous , If I have understood you correctly, and assuming that your data model is something similar to this:

 

- Create a custom column, and insert this formule:

if [Date]>= Date.FromText("2020-01-01") and
[Date]<= Date.FromText("2022-11-18") and
[Column]<>"<> 24 Application withdrawn" 
then 1 else 0

 

- The result:

 

Best regards