Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Thank you, George! Is the table in the measure formula the table that contains the data in my report?
John
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |