Forum Discussion
Solved
Calculate Yield
I need some assistance, I am trying to calculate the yield of a product (PLU) as it moves through work in progress steps. The table I am working with lists all the PLU's in on column, the net weight of each PLU in another and the date of the actual transaction to the data capture system in another. I am trying to figure out how I can visualize the percent difference between finished net weights of two different PLU's in a date range. Any help would be appreciated. Sample data attached. Thanks in advance
11 Replies
Hi DIROPS ,
To do this, you would need to specify both PLUs. Assuming you would always be comparing 2 only, you could do the following:
1. Create a calculated table with 2 columns, like this:
PLUs = CROSSJOIN(SELECTCOLUMNS(DISTINCT(PLU_Table[PLU_Column]),"PLU Numerator",[PLU_Column]),SELECTCOLUMNS(DISTINCT(PLU_Table[PLU_Column]),"PLU Denominator",[PLU_Column]))2. Create a calculation:PLU % Yield =var num = IF(HASONEVALUE(PLUs[PLU Numerator]),CALCULATE([Weight Calculation], //SUM(Weight)FILTER(Store, Store[Store Country] = VALUES(PLUs[PLU Numerator]))),0)var den = IF(HASONEVALUE(PLUs[PLU Denominator]),CALCULATE([Weight Calculation], //SUM(Weight)FILTER(Store, Store[Store Country] = VALUES(PLUs[PLU Denominator]))),0)return DIVIDE(num, den)For the dates, that should work just by filtering.Hope this helps,Nathan
