Forum Discussion

pulikkan's avatar
pulikkan
Frequent Visitor
8 years ago
Solved

Combine values of multiple rows into one row

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 hav...
  • Greg_Deckler's avatar
    8 years ago

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

  • Jay7's avatar
    8 years ago

    Group By option in power query editor will do this.

     

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