Column Distribution (in Power Query) - Calculation of Unique Value

[AzizQuazi]

Hello all,

I am missing understanding how the Unique value is calculated in the following example. I do understand the distinct part (example in the column IsDeliver -> 3 distinct = TRUE, FALSE and null.). I don't see any option to attach the PBIX - is there? Thanks in advance for your help.

Best Regards,

Aziz

[AzizQuazi · Accepted solution]

Thank you so much @Vera_33, what a great community. Though I took another half-an-hour to understand the Group By concept - finally managed to understand it completely. A great relief. Thank you so much again.

Cheers...Aziz

[Vera_33]

cool, @AzizQuazi , it is the learning process, enjoy!

[Vera_33]

Hi @AzizQuazi 

I was confused earlier, too. Unique value is when you groupby the column and find the count =1, for IsDeliver column, only null is unique, for QTY column is {25,7,9,18,27,3}, total 6