Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Dear Expert,
I need to do following in Power BI, I need to have the calculation as below, any one can help.
Total | |
Revenue | 100 |
Cost | 90 |
Gross Profit | 10 |
Gross Margin | 10% |
Equation as below:
Gross Profi = Revenue - Cost
Gross Margin = (Gross Profit / Revenue ) * 100
Regards,
Solved! Go to Solution.
Hi @ahamdan,
=> Simply, I am trying to do P&L and I need it to be in the same format as I mentioned.
So did you mean that you want to make the Gross Profi and Gross Margin also in the same column with Cost and Revenue? If so, I'm afraid it cannot be achieved in Power BI.
You should know that Power BI is a data analytics tool. We can create a new calculated column or a measure to calculate value based on the source table. However it is not possible to insert the calculated value into the source table. This should be done at data source side.
Thanks,
Xi Jin.
Hello All,
Kindly can you help to create simple profit and loss table in power bi by row wise and data is exported from excel as below,
Accounts Amounts
Cost 50000
Revenue 100000
Gross Profit 50000
% Profit 500
Link https://community.powerbi.com/t5/Desktop/Profit-Loss-on-Matrix-Table-in-power-BI/td-p/508365.
Example
sorry i need in column wise pls
Hi @ahamdan,
Based on your sample data, the Revenue and Cost are in one same column. So is it true as they are truly in one same column?
If so, the formula for Gross Profi can be like this:
Gross Profi = CALCULATE ( MAX ( Test[Value] ), Test[Column] = "Revenue" ) - CALCULATE ( MAX ( Test[Value] ), Test[Column] = "Cost" )
And Gross Margin can be:
Gross Margin = DIVIDE ( [Gross Profi], CALCULATE ( MAX ( Test[Value] ), Test[Column] = "Revenue" ) )
If the Revenue and Cost are came from other measures. Please don't be lazy to share use your acutal situation. Since we can't see your real data, it'll help us a lot to understand your requirement if you can share us your actual sample data and the measure formulas.
Thanks,
Xi Jin.
Thank you Sir,
Yes Cost and Revenue are in the same column.
Simply, I am trying to do P&L and I need it to be in the same format as I mentioned.
Hi @ahamdan,
=> Simply, I am trying to do P&L and I need it to be in the same format as I mentioned.
So did you mean that you want to make the Gross Profi and Gross Margin also in the same column with Cost and Revenue? If so, I'm afraid it cannot be achieved in Power BI.
You should know that Power BI is a data analytics tool. We can create a new calculated column or a measure to calculate value based on the source table. However it is not possible to insert the calculated value into the source table. This should be done at data source side.
Thanks,
Xi Jin.
Thanks for your reply.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |