Forum Discussion

toddpbi's avatar
toddpbi
Icon for Helper II rankHelper II
8 years ago

Financial Statement IF ( SWITCH

Hello there PBI community,   Recently I have been referencing an article to learn more about DAX language in an attempt to create a P&L statement within Power BI Desktop. The problem I am facing is...
Need Help
Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution Sage
8 years ago

Hello,

 

it is not that trivial to figure out without knowing the structure of your raw data.

 

Nontheless I think ALL should help you. I guess GM should be something like:

GM=CALCULATE([Rev Act]-[CoS Act],ALL(Table[SubCategories]).

 

For a more complicated P&L check here.