Forum Discussion
Calculated Column or Table?
I have the data output in my tables for Sales Value and Sales Volume. To get Sales Volume share and Sales value share. I need to do a manually copy and paste and calculation to get the output, two reports at bottom please?
see https://drive.google.com/file/d/1lIXHGQWVv4N-OqFdD1o3V99XQOcp6TJ1/view?usp=sharing
The following is the data output that i currently have, see: https://drive.google.com/file/d/1vzZP7crsCAGsXgzrJ7TJBrJsGwGPrjNR/view?usp=sharing
How do i outomate the process in powerbi, using dax or any other relevant functions to get the desired output?
@amitchandak @lbendlin @PhilipTreacy
1 Reply
Yrstruly2021 , No access to files. I applied for. Also, the problem is not very clear.
Please refer to these two videos to move data from one table to another, if that can help
