Forum Discussion
Solved
Production Yield Calculation
Hi, Will like to calculate production roll yield. 1) Below is "Roll yield" calculation using excel for each Line1-Line4 =IF(ISERROR(D3),1,D3)*IF(ISERROR(G3),1,G3)*IF(ISERROR(J3),1,J3)*IF(I...
Sure thing.
Please give this a try and let me know how you get on, :)
Hi Phil,
Super. What a clean and easy solution. Love the awesome response in this forum. Power Support, Power BI!
phil,
Help! If the original data has a column "testdate", how can I add the "date" colum to the new Table "Yield Roll Table".
Tired to add "data[testdate]" in the DAX formula, but it messes up the "Yield" Calculation, giving a incorrect Yield results.
Yield Roll Table =
SUMMARIZECOLUMNS(
data[Area],
data[Line],
data[station],
data[testdate],
"Count of Pass",COUNTROWS(FILTer('data',[test results]="P")),
"Count of Fail",COUNTROWS(FILTer('data',[test results]="F")),
"Yield",DIVIDE([CountPass],[CountPass]+[CountFail],1)
)