topic Combine values of multiple rows into one row in Developer

Combine values of multiple rows into one row

pulikkan — Tue, 24 Jul 2018 17:08:48 GMT

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.

Re: Combine values of multiple rows into one row

Greg_Deckler — Tue, 24 Jul 2018 17:33:08 GMT

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

Re: Combine values of multiple rows into one row

Jay7 — Wed, 25 Jul 2018 05:52:13 GMT

Group By option in power query editor will do this.

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