Forum Discussion
How to build income statement from transactions
Hi experts,
I am trying to build a income statements from transaction level from general ledger (only money amount) and sales record (for quantity). On transactional level only separate income statement items. So I build a income statement items for the calculated parts like gross profit, net profit....
And I want the format to standup like this. I want to get GP - FG as Sales - FG minus COGS - FG. But couldnt find a way to do it. How could I put calculated row into powerBI? Counldnt figure out a way to do it > <
Much appreciated for the help.
1 Reply
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
