New Column C % = (Column A - Column B) divide by Column A

[sdhn]

Helllo All,

I am using Powr Bi desktop.

I need to create new column based on following logic:

New Column C % = (Column A - Column B) divide by Column A

Any help will be appreciated.  Thanks 

[negi007]

@sdhn you can easily create a new columns in your dataset 

New Col = (Prod_Tab[Sales]-Prod_Tab[Profit])/Prod_Tab[Sales]

[sdhn]

Correct way below:

New Column C %= DIVIDE(TableName[Column A]-TableName [Column B], TableName[Column A])

[sdhn · Accepted solution]

New Column C % = DIVIDE(Table[Column A]-Table[Column B], MVision[Column A)

worked