Subtract Two Columns - New BI user

[sea_sriram]

Dear All

Good day. Am new to Power BI - just getting used and watching some online training.

Here is my question.

I have two columns.

Each column has 10 data fields

I would like to subtract column A from Column B and have the results in Column C.

Can someone help me on how to do it?

Thanks

Sriram

[Greg_Deckler]

Are you saying that each column has values in 10 rows? If the columns are numeric then @Anonymous's formula will work if you create a new column and give it the formula he provided.

[Anonymous · Accepted solution]

Hi @sea_sriram

Create a calculated column 

ColumnC =  ([ColumnA] - [ColumnB] )

If this works please accept it as a solution and also give KUDOS.

Cheers

CheenuSing

[Anonymous]

hi

Encouraged by above - if subtraction is to be done with a column say buy-sell in this example, what wud it be pls?