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

[cmsam]

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

Data source:

Matrix

[danextian]

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.

[Anonymous]

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]

@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...