Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Report with PowerPivot / Excel
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
Headers Table
PBID File : https://app.box.com/s/asgsn4b2ku885t94zmg68nzgykwyxktk
Any Help?
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |