Forum Discussion

davidson929's avatar
davidson929
Regular Visitor
8 years ago
Solved

Sum Like Values from Differing Columns

Hello,   I am trying to sum like values from different columns across multiple records. I can't seem to figure out to how to get them to sum all together.   Here is an example data set: Record I...
Need Help
  • drewlewis15's avatar
    drewlewis15
    8 years ago

    One option would be to unpivot your Category columns using the Power Query Editor 

    1. Click Edit Queries
    2. Select all Category columns
    3. Go to the Transform tab and click "Unpivot Columns"

     

    This will take your table that currently looks like this:

     

    And turn it into this:

     

    You can now create a visual and simply drop the "Value" column (or whatever you end up naming it) into both the Axis (or legend) and Value fields (Count of Value).  Finally, just filter the visual to not include records where the value is blank.

     

drewlewis15's avatar
drewlewis15
Solution Specialist
8 years ago

One option would be to unpivot your Category columns using the Power Query Editor 

  1. Click Edit Queries
  2. Select all Category columns
  3. Go to the Transform tab and click "Unpivot Columns"

 

This will take your table that currently looks like this:

 

And turn it into this:

 

You can now create a visual and simply drop the "Value" column (or whatever you end up naming it) into both the Axis (or legend) and Value fields (Count of Value).  Finally, just filter the visual to not include records where the value is blank.