How to calculate percentage in rows?

[Anonymous]

I have a data like the following  And I want to calculate the share percentage as

Shares = sum(Stocks[quantity])/Stocks[quantity] and express in percentage.How can I do it?

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I suggest you to create a calculated column. It is very quick and convenient to implement.

Column = SUM(Table1[Quantity])/Table1[Quantity]

If I understand incorrectly , please tell more details. Then I can help you as soon as possible.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.