Forum Discussion
Balance Sheet & Income Statement in PowerBI
Hi BhaveshPatel
this might help: http://www.thebiccountant.com/2016/07/21/easy-profit-loss-account-scheme-reports-power-bi-power-pivot-dax/
It connects to the Contoso-DB. Haven't checked, but there might be balance-sheet figures in it as well.
Hi BhaveshPatel
this might help: http://www.thebiccountant.com/2016/07/21/easy-profit-loss-account-scheme-reports-power-bi-power-pivot-dax/
It connects to the Contoso-DB. Haven't checked, but there might be balance-sheet figures in it as well.
Much Appreciated. I would like to show to the accounting students how you can use powerbi to create such reports in PowerBI.
One Product = Many applications.
Thank you once again.
Kind Regards,
Bhavesh
Hi Bhavesh
We are building Income Statment and Balanace Sheet reports using power BI. We are facing two problems.
1. How to subtract two subtaotla to get Gross Profit and Loss values. Detailed problem is expliane in below ticket.
https://community.powerbi.com/t5/Desktop/Profit-Loss-on-Matrix-Table-in-power-BI/td-p/508365
2. When we show to the total in the end we want insted of total subtraction of Assets- (Liabilities & Euqity)=0
We are able to get this for Selected month with below measure not how to apply time dimension on those to get Prior month, Prior Qtr, Prior Year
Thanks
Smita
