Subtracting Data in One Column

[Anonymous]

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

[judspud]

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]

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

John

[judspud · Accepted solution]

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