Forum Discussion
Generate column with count of values
Hi all, I am working with a dataset and merging another set and applying filters. At some point I am getting the “Value” column (see screenshot). However, the values are a sum of each of the “Pr...
Hi, I also struggled to find any help online with this issue.
My approch has been (in power query), to select the column I want to count, and go to group by, click on the advanced tab and give the new column a name, select count rows, then add another column underneath and select all rows.
when you click ok, you should get the column you wanted to group by, a count of the values and a column with a table you can expand
expanding return your orginal columns, plus the count of selected values in a new column.
I hope this helps with your query. 🙂