Forum Discussion

ahamdan's avatar
ahamdan
Frequent Visitor
8 years ago
Solved

Calculate Gross margin in Profit and Loss statement

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% ...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    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.

     

dineshksh's avatar
dineshksh
New Member
7 years ago

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

  • dineshksh's avatar
    dineshksh
    New Member
    7 years ago

    sorry i need in column wise pls

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Link https://community.powerbi.com/t5/Desktop/Profit-Loss-on-Matrix-Table-in-power-BI/td-p/508365.

     

    Example

    A_SwitchedMeasures_GroupPKR = sumx(ListMeasure_Group,
    SWITCH([Selected_Measure_Group],
    1,[A_Tot_Rev_PKR],
    2,[A_COR_PKR],
    3,[Margin_A_PKR],
    4,Divide([Margin_A_PKR],[A_Tot_Rev_PKR])*100,
    5,[A_Practice_OH_PKR],
    6,([Margin_A_PKR]-[A_Practice_OH_PKR]),
    7,[A_Sell_PKR],
    8,[CM_A_PKR]-[A_Practice_OH_PKR],
    9,Divide([CM_A_PKR]-[A_Practice_OH_PKR],[A_Tot_Rev_PKR])*100,
    10,[A_AdminExpenses_PKR],
    11,[A_OIncome_PKR],
    12,[A_Donation_Group_PKR],
    13,([A_Net Profit_PKR]+[A_OIncome_PKR]-[A_Donation_Group_PKR]),
    14,Divide(([A_Net Profit_PKR]+[A_OIncome_PKR]-[A_Donation_Group_PKR]),[A_Tot_Rev_PKR])*100
    )
    )
    Ghulam Abbas
    03065297514