Forum Discussion

Henriquesm's avatar
Henriquesm
New Member
2 years ago

Statement of Income - Calculate Rows

One question, how do I calculate between Lines in Power BI, in my case I have a statement of income with some values ​​but some without some totalized Lines.
This way I need to add some lines to fill the gap in the column I have

 

Example:

Credit: 100
Capture: 20
Commission: 60
Others: 20
Gross Margin: (sums of items above)

Provisions: 50

Net Margin (sum of Gross Margin (-) Provisions)

Expenses: 50

Net Profit: (sum Net Margin (-) Expenses)

 
1 Gross Margin, Net Margin and Net Profit are already included in the structure of My table, you would only need to do the calculation so that the value can fit into the Lines

2 Maybe they say that it would be better to bring the information already added into Power BI but it comes from the SAS System which makes this calculation impossible

Would there be a way to do these calculations in the column as explained above?


I also leave a print attached to help with understanding.

Thanks in advance

1 Reply