In my PnL statements, it breakdowns into few main categories as follow:-
-Revenue
-COGS
-Other Income
-Staff Cost
-Other Expenses

Please advise how could I insert Gross Profit (ie Revenue - COGS) in the PnL statements in PowerBi. In addition, how could I present the above in sequence and add in the additional row measures of gross profit and net profit.

I tried recreating P/L by applying techniques shown in â€śFinancial Reporting in Power BI - March 2018â€ť tutorial video. Itâ€™s a general success, however, there are quite a few observations where I would like to seek your advice/opinion:

for expenses, % variance sign (this year - last year / last year) is worked out correctly for all those expenses if this year number is more than the last year. however, when this year number is less than last year it shows % variance with wrong sign (like in my case: this year number is - 2198, last year number is - 2748; whereby - denotes expenses, % variance should have appeared as +20% but it appears -20%

if last year expense number, due to certain adjustments/reversals, appears as +ve instead of -ve and this year number is -ve (like in my case: this year number is - 820, last year number is +286; whereby - denotes expenses, % variance should have appeared as -ve% but it appears 387%

Thank you, for a usual quick response.
Pls see the image pasted below:

formulas used are:

% Var =
SWITCH( TRUE(),
[Selected Metric] = "vs Last Year", [% Var. to LY],
[Selected Metric] = "vs Budget", [% Var. to Budget],
[% Var. to Budget] )
% Var. to LY =
IF( ISBLANK( [LY Actual ('Mln)] ),
BLANK(),
DIVIDE(ABS([Actual ('Mln)] - [LY Actual ('Mln)]) , [LY Actual ('Mln)] , 0 ) )

Thank so much. You truly are a â€śBIGeniusâ€ť. Issue is settled now.

Just wanted to know about your plans to cover Balance Sheet and Cash Flow Statements, historical as well as forecast, it would be a great help to many of us.

Recently Iâ€™ve created some new and relevant content on this particular topic of indenting sub-totals.

Check out the below video tutorials

Also during this live member only workshop I really detailed a financial reporting templates technique which solves this for Power BI users looking to create specific financial reports.

Hi All
I am Fabio and working on big data advanced analytics. I am new with PowerBI and despite I really enjoy learning and working with it I am still struggling for some really â€śeasyâ€ť stuff. I would like to ask your support about the following cumulative calculation:

I need to calculate the values of scrap over a process. In attachment you can find the PowerBI Model

I Have 100 product and for each product I have â€śYâ€ť Process step to produce it (letÂ´s take as example the â€śproduct 10â€ť â€“ with 5 process steps)

The values (cost) of my product increase for each process step. For this reason I have to consider the cumulative cost for the scrap cost calculation

The Value of my product is give by the sum of â€śBOM costâ€ť + â€śLabourâ€ť + â€śProcess costâ€ť

Set Up Scrap cost per one pc produced are = Set up scrap * Cumulative total cost without scrap / Batch size

When I calculate the â€śCumulative total cost without scrapâ€ť the calculation is correct but when I used this measure to calculate the â€śSet up Scrap costâ€ť I got wrong number

PowerBI use the column of â€śTotal cost without scrapâ€ť instead of the â€ś Cumulative total cost without scrapâ€ť despite I have specified the right measure

See â€ścheck.xlsxâ€ť file column â€śTâ€ť (the correct calculation) and column F (the wrong PowerBI Calculation) / Column U (Check wrong calculation).