Pivot table powerbi

[viralpatel21]

Hello

I am stuck in a dilemma hoping to find some help.

I was able to create the following table (up to Grand total ) using Matrix but i need to create/display the Surplus Transaction in that way.

I guess i need help creating either a column/ measure the following Surplus Transaction.

• The Surplus Transaction calculate 2 formula 
• 1) If The transaction Type is Buy and Deposit then Sum USD Amount
• 2) If the Transaction type is Buy, Sell and Deposit then Sum TxMargin

How could i do this?

thanks

viral

[amitchandak]

@viralpatel21 , I have added an additional row calculation example here. see if that can help

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU

[viralpatel21]

Hello @amitchandak 

I tried to attempt this for my data but i cant seem to do it (kind of a newbie in this) in the video your using excel to determine the Total for each and then adding a number.. However im connected straight to a database??

how would i use it?