Combining/grouping/total by category in Power Bi

[Anonymous]

Hi All,

I am struggling to figure out how to combine my different item codes to get a singular row for each item code total.

This is what my data looks like now (Below). 

Item code.	Location.	On hand.	on order.	committed.	back ordered.
a	1	40	5	0	0
a	2	30	10	10	0
a	3	5	10	5	5
a	4	70	20	0	5
a	5	60	15	0	0
b	1	20	40	0	5
b	2	20	20	5	10
b	3	10	0	5	0
b	4	5	10	0	0
b	5	30	50	10	5

This is what I would like my data to look like. (Totals)

Item code.	on hand.	on order.	committed.	back ordered.
a	205	60	15	10
b	85	120	20	20

If this is possible and anyone could give me a hand i would be very grateful.

Thanks

[amitchandak · Accepted solution]

@Anonymous , In a visual data for the numeric column, should some by default.

or sum measure for all these column.

If you want a new table(data), then use group by in power query

https://docs.microsoft.com/en-us/power-query/group-by