Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Income Statement Power BI - EBITDA

Hi all, I was able to create income statements down to bottom line net income for the company that I work for using the method within the following post:

https://www.thebiccountant.com/2016/07/21/easy-profit-loss-account-scheme-reports-power-bi-power-pivot-dax/

 

However, I am hoping to add "EBITDA" to the report that I am creating as the bottom line item on the statement. I am struggling to do this following the method outlined in the above post because essentially I need a way to add back interest, taxes, depreciation and amortization to the Net income line item on the report. In summary, my question is how could I add an EBITDA line item to the report that takes net income, backing out the components listed above? Please let me know if anyone can offer any insight. It would be greatly appreciated!