how to calculate commission 10% of the columm

[haozhong · Accepted solution]

1. Right click the existing table

2. Choose add column

3. In the formula field, replace "Column =" with this:- 

Commission = 'Commission Table'[Sales]*10/100

Note:-

a) 'Commission' is the new column name

b) 'Commission Table' is the table name

c) 'Sales' is the sales column in the table

d) '*10/100' calculates 10% of the sales column