Forum Discussion
Separate Values in Column Compared to SUM from another Column
Please find the sample. Thank you.
https://drive.google.com/file/d/1OAq0HrmsC3KPq-_LiK-nbV_eeVeWJJOA/view?usp=sharing
Hi Anonymous ,
I am not sure if it is achievable in Power BI - perhaps a combo of Power Query and DAX is needed. But that aisde, where is volume produced in your data?
- Anonymous3 years agoNot applicable
Hi danextian ,
Receipt Qty in Alt.UoM is "volume produced".
I am using "Smash_Fact" Table. This table is the combination of "Albatross" and "ZPOCL".
- danextian3 years ago
Super User
Hi Anonymous ,
Please also post your data source. My initital assessment requires modifying the table in PQ.
- Anonymous3 years agoNot applicable
Hi danextian
Shared a zip with the sample files. Also, a file named "output of model" is attached, to explain how the output is requested.
https://drive.google.com/file/d/10I9KUu-eRME7Vm0MmdifOueaU7ZK_1aK/view?usp=sharing