Forum Discussion
Need Help
Hi,
Please find the below requirement.
I have data like below , i know the total cost of each project and individual employees revenue.
Now I need to calculate profit and profit percentage based on total cost and total revenue.
total profit = total revenue - total cost.
Indivial profits = total profit / total revenue * revenue
profit percentage = individual profit / total profit * total profit percentage
I have calculate in one filed, same as for remainig one. can you please help me to generate report in power bi.
| Project | Empno | Empname | Cost | Revenue | Profit | Profit Percentage |
| Project 1 | 1 | A | 30000 | 46000/81000*30000=17037 | 17037/46000*56.79=21.03 | |
| Project 1 | 2 | B | 15000 | |||
| Project 1 | 3 | C | 36000 | |||
| Project 1 | 0 | Dummy | 35000 | 81000 | 46000 | 56.79 |
| Project 2 | 5 | E | 36000 | |||
| Project 2 | 6 | F | 28000 | |||
| Project 2 | 7 | G | 39000 | |||
| Project 2 | 0 | DUmmy | 47000 | |||
| Project 3 | 9 | I | 25000 | |||
| Project 3 | 10 | J | 30000 | |||
| Project 3 | 11 | K | 40000 | |||
| Project 3 | 0 | Dummy | 50200 |
2 Replies
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139
HI,
Below is data, I want to calculate profit and profit percentage for below data in pwer bi.
If I filter project column then it should be calcualte based on filtering and should be dispaly profit and profit %
Example - if i filter project1 -> profit should be calculated revenue - cost
-> profit % should be calculate profit / revenue.
- if I filter project 2 & 3 -> Profit should be calculate for these two (total revenue) - total cost
-> Profit % should be calculate total profit / total revenue.
Project Empno Empname Cost Revenue Project 1 1 A 30000 Project 1 2 B 15000 Project 1 3 C 36000 Project 1 0 Dummy 35000 Project 2 5 E 36000 Project 2 6 F 28000 Project 2 7 G 39000 Project 2 0 DUmmy 47000 Project 3 9 I 25000 Project 3 10 J 30000 Project 3 11 K 40000 Project 3 0 Dummy 50200
