Forum Discussion

viralpatel21's avatar
viralpatel21
Helper II
3 years ago

Pivot table powerbi

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

Need Help
Show and Tell
Tutorial Requests

2 Replies

    • viralpatel21's avatar
      viralpatel21
      Helper II
      3 years ago

      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?