Forum Discussion
calculated field
Need help on calc field per company as buy and sell are 2 diff rows. They need to be net off to get the profit from the transaction done that day... hope somewat clear
Hi Anonymous ,
Can you please explain a little bit better what is the expected result?
Hi Anonymous ,
If you use a matrix visualization and place the Trans column in the columns you get the expected result:
This depends on how you want to setup everything but then making some measures you can have the results has you need.
5 Replies
Anonymous,
If I understand correctly, your first step in PowerQuery is to Pivot your "Trans" column.
This should create two new fields "Buy" and "Sell".
Then you can create Measures from these.
Hope this gets you pointed in the right direction.
Hi Anonymous ,
Can you please explain a little bit better what is the expected result?
let me try again - am trying to get a summary say as pivot in excel of buy and sell trnsctions a day over few days. sheet 'b s indiv' is the base data
Thnx in advance
Hi Anonymous ,
If you use a matrix visualization and place the Trans column in the columns you get the expected result:
This depends on how you want to setup everything but then making some measures you can have the results has you need.
