Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Anonymous ,
Can you please explain a little bit better what is the expected result?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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
Your description is not very clear. What are your needs ? What kind of effect do you want to achieve ? Can it be reflected in the form of pictures or data, if possible, please provide your pbix file (remove private information) .
Best Regard
Community Support Team _ Ailsa Tao
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Can you please explain a little bit better what is the expected result?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |