Forum Discussion

marsclone's avatar
marsclone
Icon for Helper IV rankHelper IV
8 years ago

Calculated Rows P&L

I have been greatly helped by another user but i didn't find the right solution   This is my testfile   Test   I want to create a P&L in Power BI. I have my costs and revenues in one column whi...
Need Help
Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
7 years ago

marsclone , v-lili6-msft Yes it is possible.

 

See how.

 

Assumptions (see in PowerQuery): Revenue values are positive. All others negative.

 

Best regards

Fábio Coatis

marsclone's avatar
marsclone
Icon for Helper IV rankHelper IV
5 years ago

Hi Fcoatis!

 

I hope you are doing well?

I want to thank you after all this time for your solution. Your solution is in the end the best option for me.

Personally i work with Power BI, but in my work i only can work with Power Pivot/Power Query.

And your solution is the only one that also works in this situation.

 

After all this time i also would like to build a balance sheet in the same way. The question is, is that possible?

I tried to use your measures, but in the case of the Balance the subtotals work different. 

 

I've added a testfile and the endresult should look this.

 

TEST 

 

I really hope you can help me with this? Very thankful in advance.

 

Kind regards

Marcel