May 6, 2022
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.
January 31, 2022
February 13, 2021