Separate Values in Column Compared to SUM from another Column

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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". 

[danextian]

Hi @Anonymous ,

Please also post your data source. My initital assessment requires modifying the table in PQ.

[Anonymous]

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 

[danextian]

Hi @Anonymous ,

Please post  a sample data that can be copy-pasted as text. 

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2867986#M987855