Forum Discussion
Counting values in multiple columns
I am needing help on how to get the count or total of each different category value from both the "VOC Issue" and "VOC Issue 2" combined. Below is my data and then an example of the results I'm looking for.
Behavior | 4 |
| Billing | 4 |
| Change | 1 |
| General | 1 |
| Technology | 1 |
=Table.Group(Table.FromColumns({Table.Column(PreviousStepName,"VOC Issue")&Table.Column(PreviousStepName,"VOC Issue 2")},{"VOC Issue"}),"VOC Issue",{"Count",Table.RowCount})
8 Replies
=Table.Group(Table.FromColumns({Table.Column(PreviousStepName,"VOC Issue")&Table.Column(PreviousStepName,"VOC Issue 2")},{"VOC Issue"}),"VOC Issue",{"Count",Table.RowCount})
Thanks for the response, but it still a bit new to this. Could you explain a bit? Also would this be added as "new column" or "new measure"? I tried copying it into both and got errors.
Hi, wdx223_Daniel provided Power Query solution - so you should add his code as a new step in your Power Query query.
