Need help - For creating a dashboard using P&L summary

[Anonymous]

Hi Everyone ,

I am fairly new to the PowerBI. I have a requirement from my boss to create a dashboard through Power BI based on below data. I have the below summary data in excel which includes formulas but when I add it as a table and upload the data to powerbi desktop it will updload as it is even the totals considered as values . I need to show the EBITDA in data cards department wise and Year to Date EBITDA month wise through a column chart. Below data is just for one month and i will have the similar table for the 12 months in total .

Please help !

[v-lionel-msft]

Hi @Anonymous ,

Please provide the reproducible original data in table form and expected output results.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Anonymous 

To build Financial Statements in Power BI, it requires some initial steps to structure your report template and DAX formulas for various p&L matrices.

Follow these links to learn more and adapt them to suit your needs.

https://www.youtube.com/watch?v=vxKDWjgN2oc
https://exceleratorbi.com.au/build-a-pl-with-power-bi/

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn