Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

How to add a calculated rows to Power BU Matrix for presenting a P&L statement?

How to add a calculated rows to Power BU Matrix for presenting a P&L statement?

Data source:





















Super User
Super User

Hi @cmsam ,

You  will need to create a dimensions table containing the rows you need and use a measure to return the desired value  based on the current row value from that column. I have attached a sample pbix to help you get started with.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Hi @cmsam ,

Thank you for @danextian and @amitchandak answer,

Have your question been solved, if so please mark the correct answer as a reply!

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Super User
Super User

@cmsam , Refer if blog and videos can help


Power BI How to get the P&L formatting right:
Power BI How to get two columns format Profit and Loss Statement(P&L) right:

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors