The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:)
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.
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |