Forum Discussion
P and L Matrix help
I'm creating a P and L matrix. I'm working on two methods, one using the Profitbase matrix, the other based on using the Power BI matrix itself (as this opens up other opportunities, eg tooltips, dri...
AndyDD_UK , calculation groups can help to reduce measures
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
for formatting consider
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-e39ca822908a