Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Subtracting Data in One Column

Hi: Let's say that the data in your second column in Power BI displays either "Income" or "Expense".  Further, let's say that you have their figures in the third column. How do you, then, have Powe...
Need Help
  • judspud's avatar
    judspud
    6 years ago

    Hi Anonymous 

     

    Correct, you should replace 'Table' with the table name from your data model. 

     

    And the text within the square brackets [ ] to your column names.

     

    Thanks,

    George

judspud's avatar
judspud
Solution Supplier
6 years ago

Hi Anonymous 

 

You can create a measure that totals income and subtracts expenses

 

Measure = calculate(sum('Table'[Value column]),'Table'[Type] = "Income") - calculate(sum('Table'[Value column]),'Table'[Type] = "Expense")

 

Hope this helps

 

Thanks,

George 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you, George!  Is the table in the measure formula the table that contains the data in my report?

    John

    • judspud's avatar
      judspud
      Solution Supplier
      6 years ago

      Hi Anonymous 

       

      Correct, you should replace 'Table' with the table name from your data model. 

       

      And the text within the square brackets [ ] to your column names.

       

      Thanks,

      George