Hello everyone,
I am making a P&L in Power BI with a direct query connection with SAP data and a hierarchy from SAP. The situation is that the SAP hierarchy could not be changed. I want to format the hierarchy with some small changes. How do i fix this at the best way? Is it possible with DAX?
In the attachment i have provided a p&L file and some example data.
Revenue is a positive number and costs are negative. This two minus each other is the subtotal of the EBITDA.
What i want to create is the following:
GL_account_level 3 Revenue
Gl_account_level 4 Revenue Revenue cars
GL_account_level 3 Costs
Gl_Account_level 4 Cost Loan costs
EBITDA (subtotal)
GL_account_level 3 Depreciation
Gl_account_level 4 Depreciation Depreciation cars
EBIT (subtotal)
GL_account_level 3 Interest
(Regular exploitationresult subtotal)
GL_account_level_3 Extraordinary income and charge
Subtotal result before tax
The current situation is the following:
EBIT (level 1)
EBITDA (level 2)
Revenue (level 3)
Revenue cars (level 4)
Costs (level 3)
Loan costs (level 4)
Interest and depreciation (level 2)
Extraordinary income and charge (level 1)
Extraordinary income and charge (level 2)
Extraordinary income and charge (level 3)
Total Power BI result before tax
I am searching very long for a good way how to fix this, so if anyone can help me i'm very happy:)
