Forum Discussion

TestDummy's avatar
TestDummy
Regular Visitor
2 years ago
Solved

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 looki...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    =Table.Group(Table.FromColumns({Table.Column(PreviousStepName,"VOC Issue")&Table.Column(PreviousStepName,"VOC Issue 2")},{"VOC Issue"}),"VOC Issue",{"Count",Table.RowCount})

dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi, wdx223_Daniel provided Power Query solution - so you should add his code as a new step in your Power Query query.

 

TestDummy's avatar
TestDummy
Regular Visitor
2 years ago

I did that and now I get an expression error of 'PreviouseStepName' not recognized.

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

    You have to replace 'PreviousStepName' with your previous step reference.

    • TestDummy's avatar
      TestDummy
      Regular Visitor
      2 years ago

      I don't know what that is/means. Like I said I am still fairly new this. Could you explain a bit?