Forum Discussion
Separate Values in Column Compared to SUM from another Column
Hello all,
I need a help with PowerBI. Measure or a custom column function would work, I prefer a DAX measure.
I need the image without color to look like the one with color. Attached.
Logic: Image 1, both are different table merged with the help of a left outer join based on header material number.
** A material can have multiple batches.
Volume produced should sum up and equal quantity units, extra amount of volume produced should move to the next cell in the same logic and equal quantity units again. Leftovers go to the next cell with same logic. Thanks for help.
Inputoutput
6 Replies
- danextian
Super User
Hi Anonymous ,
Please post a sample data that can be copy-pasted as text.
Please find the sample. Thank you.
https://drive.google.com/file/d/1OAq0HrmsC3KPq-_LiK-nbV_eeVeWJJOA/view?usp=sharing- danextian
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?
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".
