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.
rsbin
Community Champion
Community ChampionAnonymous,
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.