Forum Discussion

sea_sriram's avatar
sea_sriram
New Member
9 years ago
Solved

Subtract Two Columns - New BI user

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      hi

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

       

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    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.