Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have system driven data laid out like the below;
Month | Salesman | Invoice | Sales | Direct Consumables | Direct Payroll | etc |
Jan | X | 12345 | ||||
Jan | Y | 12346 | ||||
Jan | Z | 12347 | ||||
Jan | AA | 12348 | ||||
Jan | AB | 12349 | ||||
Feb | ||||||
Mar |
I may be wrong but to create a P&L matrix table I need the data to be like this;
Category | Jan | Feb | Mar | Apr |
Sales | ||||
Direct Consumables | ||||
Direct Payroll | ||||
Contribution | ||||
Other Costs | ||||
Other Payroll | ||||
Contribution | ||||
Overheads & Non Direct Payroll | ||||
EBITDA |
Is there any way to achieve this in power BI? I have over 5,000 lines each month so I need something with minimal manual intervention.
Thanks!
Solved! Go to Solution.
Yes, It is possible in Power BI. Please do follow the below steps,
Here you go!
Let me know if you have any issues.
Appreciate your kudos!
Regards,
Siva Mani
Check out this demo from Enterprise DNA
And a "how to" video on PnL satements, also from Enterprise DNA:
Creating PnL Statement
Proud to be a Super User!
Paul on Linkedin.
Yes, It is possible in Power BI. Please do follow the below steps,
Here you go!
Let me know if you have any issues.
Appreciate your kudos!
Regards,
Siva Mani
Thanks so much!
Glad that it helped you!
Hi,
Is to possible to do something similar to a table that has been created in PowerBI rather than imported as a query? I've had to import a table, add several calculated columns, etc to get my desired values but I need to get it laid out like the above to create a P&L.
Thanks,
Paddy
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |