Austin Jennings on 28 Jul 2023 16:38:01
The Group By function within Power Query doesn't allow someone to identify the columns that they wish to count. Power Bi seems to assume that you want to have a count of all the rows within the dataset. The issue with this is not being able to count the specific things that you want to keep track of.
For example, I want to count the number of rows within a column that is only has a value when someone enters a value there, otherwise, it's a null value. I don't want to count everything including the null values, I only want to count the number of values entered into that field.
Adding the ability to specify which column I want to count is a useful feature that Power Bi developers glanced over. Please add it!
- Comments (1)
RE: Power Query - Group By Function - Count
You can actually write whatever summary function you want if you edit a Group By in the advanced editor, so this is possible but not friendly. Like a lot of things in the Power Query editor, it would be good to improve the bridge between the simple and the possible - here by letting the main group by editor properly handle custom summaries.