DAX subtotals P&L reporting Direct Query

[Matthijs1234566]

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:)

[v-yalanwu-msft]

Hi， @Matthijs1234566 ；

Is this the result you want to present? I don't quite understand the Gl_Account_level 4 in your description.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Matthijs1234566]

https://we.tl/t-UYtrNxpLlC with a wetransfer link to the files