Skip to main content
cancel
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

Reply
cmsam
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:

Q2.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Matrix

Q1.JPG

3 REPLIES 3
danextian
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.

danextian_0-1716438357081.png

 










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.

 

amitchandak
Super User
Super User

@cmsam , Refer if blog and videos can help

 

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI
https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

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