How to make calculations for a Profit and Loss Statement in PowerBI?

[Anonymous]

Hi everyone,

I am attaching my data where I have many tables that comprise the inputs for a P&L Statement. All are connected with a calendar table. However I want to figure out how to make calculations as EBITDA (Utilidad Bruta - Sueldos Gerentes - Sueldos Personal - Gastos Administrativos) or EBIT (EBITDA - Depreciación) and so on. Also, i would like to make vertical analysis as "What percentage of sales are interest?" "What is my net earnings in % from the sales?" And so on

https://www.dropbox.com/scl/fi/okq453elw1nrmcz0dg08i/M2S2.-Neto.pbix?rlkey=au24rlvk76py34fi1g56d6gio...

Thank you in advance. 

[amitchandak]

@Anonymous , In case you need custom totals, blank rows etc refer

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