How to count rows with conditions in Power Query

[cindychanyy]

I have a dataset with country, date, and customer details. I need to summarise the dataset and show the number of customers in a country in a month. 

I need two numbers of customers, 1) crude number of customers and 2) number of customers if their [DaysPrevalent] >=1. How should I revise my query (highlighted part) to get the prevalent customer number? Thank you!

[cindychanyy]

It works! Thanks so much!

[dufoq3]

You're welcome 😉

[dufoq3 · Accepted solution]

Hi @cindychanyy, try to replace code in curly brackets for PrevalentCustomers with this:

{"PrevalentCustomers", each List.Count(List.Select([DaysPrevalent], (x)=> x >= 1)), Int64.Type}