Forum Discussion
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...
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.
Hello,
Thanks for your response. The source table comes from this blog post. You can download the raw data as well as see the structure of the tables here by downloading the excel file: http://www.thebiccountant.com/2017/01/16/easy-profit-loss-and-other-account-statements-part2/
Thanks for your response. The source table comes from this blog post. You can download the raw data as well as see the structure of the tables here by downloading the excel file: http://www.thebiccountant.com/2017/01/16/easy-profit-loss-and-other-account-statements-part2/