Combine values of multiple rows into one row

[pulikkan]

Hi Folks

Below bars are from different row values. Is there any way we can sum those row values  based on group. My columns are SubscriptionName, Type, Amount. different subscriptionName will have same type.

 

[Greg_Deckler · Accepted solution]

You could try creating a group. What is the axis of your chart? 

[Jay7 · Accepted solution]

Group By option in power query editor will do this.

Select SubscriptionName, Type as group by columns and get sum(amount)

[Greg_Deckler · Accepted solution]

You could try creating a group. What is the axis of your chart?