cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Moatasem
Regular Visitor

Income Statement Multiple Level Problem - PBID

Hi All,

 

I watched a video describing how to build an income statment (P&L) inside MS Excel using PowerPivot, I followed the steps and every thing was fine

 

Data Model
01.png

 

Report with PowerPivot / Excel
02.png

 

 

in this report "Gross Profit" GP stored in DimHeaders[Header], the GP value is calculated as a running total -there aren't any transactions in FactNetIncome with the label Gross Profit or its Account Key

 

Dollars w Sign RT:=
CALCULATE( [Dollars w Sign];
    FILTER( all( Dimheaders );
        DimHeaders[Order] <= MAX( DimHeaders[Order] )
    )
)

 

The problem is
When I started to rebuild the P&L in Power BI Desktop, the report -table visual- with the Header column only works fine (left table below) , but when I insert the next level "SubHeader1" (right table) I got two lines for GP first with Blank and the second with Sales Revenue, my expectation was getting one line for GP with the running total


03.png

 

 

Headers Table

05.png

 

PBID File : https://app.box.com/s/asgsn4b2ku885t94zmg68nzgykwyxktk

Any Help?

1 REPLY 1
igorabdo Advocate II
Advocate II

Re: Income Statement Multiple Level Problem - PBID

Hi Moatasem

Do you need help?

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors