Forum Discussion
Column Distribution (in Power Query) - Calculation of Unique Value
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
Thank you so much Anonymous, 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
3 Replies
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
Thank you so much Anonymous, 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
cool, AzizQuazi , it is the learning process, enjoy!
