Notifications
Clear all
Power Query
4
Posts
3
Users
0
Reactions
592
Views
Topic starter
We use COUNTIF, one of the statistical functions, in excel to count the number of cells that meet a criterion.
However, in powerquery , i cant see such formula.
How do we apply COUNTIF, in powerquery.
I have a sample data: Please see the attached file below:
The challenge is at the lefthand corner, while the expected output is place at the right-hand corner.
Thank you.
Posted : 17/09/2022 3:56 am
No, but you can easily replicate it by group/count and then merge the Source with the Grouped table. See attached.
Posted : 17/09/2022 4:38 am
If you don't want to merge, just group all rows and List.Count then expand. See attached. Either way your golden. 🙂
Posted : 17/09/2022 10:25 am
Topic starter
@Jessica Stewart n Rink Van..
Thank you , both methods work fine. I Appreciate.
Posted : 17/09/2022 10:40 am
