admin管理员组

文章数量:1279236

I have one table with production times, and 4 others with the nominal times. I am trying to make a calculated column that will bring in the nominal time based on the recipe and machine. I have it working with one table, but the other 3 are having relationship issues which won't allow the column to work correctly. Below is an example of my data along with my current code. Any help would be appreciated!

    CycleTime = 
IF(Hourly[Machine] = "M1" && Hourly[Operation] = RELATED(ProdTargetM1[Operation]), RELATED(ProdTargetM1[CycleTime]), 
IF(Hourly[Machine] = "M2" && Hourly[Operation] = RELATED(ProdTargetM2[Operation]) && Hourly[Recipe] = RELATED(prodtargetm2[RecipeName]), RELATED(ProdTargetM2[CycleTime]), 
IF(Hourly[Machine] = "M3" && Hourly[Operation] = RELATED(ProdTargetM3[Operation]) && Hourly[Recipe] = RELATED(prodtargetM3[RecipeName]), RELATED(ProdTargetM3[CycleTime]), 
IF(Hourly[Machine] = "M4" && Hourly[Operation] = RELATED(ProdTargetM4[Operation]) && Hourly[Recipe] = RELATED(prodtargetM4[RecipeName]), RELATED(PapHrProdTargetB02[CycleTime])))))

本文标签: