Forum Discussion
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 have same type.
You could try creating a group. What is the axis of your chart?
Group By option in power query editor will do this.
Select SubscriptionName, Type as group by columns and get sum(amount)
2 Replies
You could try creating a group. What is the axis of your chart?
Group By option in power query editor will do this.
Select SubscriptionName, Type as group by columns and get sum(amount)