cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brandaris
Regular Visitor

Vertical aggregation (income statement)

Hello Power BI user,

 

I have a challenge, which I couldn't quite figure out until now. Despite some videos about this, wherein the end result where I'm looking for can be seen, unfortunately I didn't succeed.

It seems so simple when I'm looking to the images of the end results on YouTube, for example, that I can hardly believe that I don't see the solution yet..... 

It concerns here a financial overview, in which subtotals have to be made in a matrix, such as Gross profit and EBITA.

 

I work with ledger accounts, to which I have assigned multiple levels of aggregation. For example, at the highest level:

* Revenue
* Cost price
* Operational costs.
That works fine in a matrix.

 

But I would like to show the difference between Revenue and Cost Price in a subtotal Gross Margin (Revenue minus Cost).

The same for example Operating profit (Difference between Gross Margin and Operating Costs).

 

I look forward with great interest to your "golden" solution, for which I would like to thank you very much in advance.

 

Kind regards,

Hans

 

2 REPLIES 2
Fowmy
Super User IV
Super User IV

@Brandaris 

I am not sure what sort of solution you are looking for in addition to the standard custom total lines in P&L.

Please refer to this video form Matt: https://exceleratorbi.com.au/build-a-pl-with-power-bi/


Did I answer your question? Mark my post as a solution! and hit thumbs up


Blog - Data Visualization

Website   YouTube    LinkedIn   PBI User Group

Hi Fowmy,

Thank you very much for your quick reaction.

It was just as like at the denstist's room, after making an appointment, the toothache is gone......

 

I've found one hour ago a video, with a similar solution in it, but your suggestion is surely useful also. I'll keep it in my "video-library"!

 

Kind regards,

Hans

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors