Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to find a way to add the totals together of two matrix tables on separate sheets in Power Bi. Both come from the same imported data.
I am trying to make a P&L statement which goes from Sales, to GP, to Operating expense then to Net Income and EBITDA.
I have one sheet which shows the whole walk down to Net Income as a matrix table.
But what I need to do now is add back Depreciation.
On a separate sheet I have an exhibit for depreciation as a matrix table.
How can I add them together? We had a vendor demo in and I know they did it, but I am not sure how.
Hi @Anonymous,
I am not very clear about what you were trying to achieve. Please follow this blog to provide more details.
Regards,
Yuliana Gu
What is unclear?
I have 2 sheets within a Power BI report. Both are matrix data tables with the same underlying database cube.
I need to take the grand total of one and add it to the grand total of the other.
Hi @Anonymous,
Currently, it is not supported to make calculation on row level in a Matrix. I'm afraid the requirement that to sum up grandtotals and display the results on new rows cannot be achieved.
Regards,
Yuliana Gu
Hello,
You can try joining the two tables using a concatenated column of all slicer columns on the desired page of the report.
Can you give some sample data and the expected result for better explaination?
I do not really follow what you describe. I do not think adding columns will work because I know I need to add rows.
Here is an example of the output.
Item | Value | How calculated? |
Revenue | 90,000 | |
Cogs | 1,000 | |
GP | 89,000 | Rev - Cogs |
Depreciation | 9,000 | |
All other Opex | 30,129 | |
Total Opex | 39,129 | Dep+all other |
Net Income | 49,871 | GP- Total Opex |
Depreciation | 9,000 | I need a way to add this back to net income |
EBITDA | 58,871 | Total of Net Income + Depreciation |
So everything comes from the same data source, but I have one sheet that calculates down to Net Income and another that calculates the 9,000 in depreciation. What I need to do is somehow in one dashboard Add back the depreciation. All data is from the same source
Any thoughts?
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |