Forum Discussion
Solved
How to count rows with conditions in Power Query
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...
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}
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}