Count Rows vs Count Distinct Rows

[lastnn30]

Hi

In Power Query --> Group by --> Operator: there are 2 options

Count Rows and

Count Distinct Rows.

What is the difference? I tried them both and I got the same result.

Thank you very much.

[VahidDM · Accepted solution]

Hi @lastnn30 

You get the same result because you data table has Distinct rows.

If you add a duplicate/same row to the table then the result will be different.

In General, Count Rows will count all rows disregarding the Distinct rows (values), but Count Distinct Rows will count the same rows as 1 row.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/