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 Power BI subtract the expenses from the income?

True, there is a "Total" at the bottom of the report.  But, this is the total for all of the data from the report's table before I filtered on the second column for only "Income" and "Expense".

Thank you!

John

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

3 Replies

  • 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