Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |