Forum Discussion

Brysonds's avatar
Brysonds
Icon for Helper III rankHelper III
9 years ago

[Need Help] Adding measures to Matrix for Profit and Loss Report

Hi Everyone,   I am curious if it's possible to build a traditional P&L report in Power BI. I know that if I start with a table that is already in P&L layout, this works fine (see example 1). Howev...
Need Help
VP's avatar
VP
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

You will not be able to add Measure to Row or column section.

 

In order to solve you problem, you can perform action in Power Query or Data model

 

For reference, There is excellent report prepared by partner (SENSDAT - Power BI Profit and Loss & Balance Sheet Solution):- SENSDAT - Power BI Profit and Loss & Balance Sheet Solution