Need help modifying a production number based on other data points

[jaymetbar]

New to Power BI and I am trying to generate reports based on our production cells. I am ultimately trying to piece together something more complicated than this, but I am stuck at this current point of the problem.

Overview: We produce lbs. of product out of different vessels. We have the vessels that we harvested noted in a day. We need to pull a piece of production out of each vessel to sample the quality. We take all those samples and assign their production lbs. to an arbitrary Vessel #1 for the day. 

Please see the data below:

Production Date	Vessel Number	Production
1/1/1999	11	11654
1/1/1999	12	10976
1/1/1999	13	12673
1/1/1999	14	10769
1/1/1999	15	10628
1/1/1999	16	12563
1/1/1999	17	10290
1/1/1999	18	10031
1/1/1999	19	12518
1/1/1999	20	12246
1/1/1999	1	2645
1/2/1999	21	12310
1/2/1999	22	11833
1/2/1999	23	10139
1/2/1999	24	11800
1/2/1999	25	11702
1/2/1999	26	10470
1/2/1999	27	12182
1/2/1999	28	10665
1/2/1999	29	10880
1/2/1999	30	10037
1/2/1999	1	2758

What I'm trying to accomplish:

I need to create a new column that runs along side the "Production" column which calculates the true vessel production based on the sample weight being added back to the vessel production.

The formula should be something like:

True Vessel Production = (Vessel Production + (Vessel #1 Production Weight/Count of Vessels Harvested in a day  <> 1)

For example, the True Production for Vessel #11 on 1/1/1999 should equal to:

TP = (11654+(2645/10)) = 11919

I hope this request makes sense. Please let me know if you have any questions and I'd be happy to clarify.

I'm hoping to use this number to calculate a vessel efficiency since I can calculate what the theoretical production should be. I may need help averaging a value between the dates that a certain vessel was harvested, but that's a question for another time.

I appreciate the help!

[Greg_Deckler]

Here is the PBIX I used if it helps (attached below)

[Greg_Deckler · Accepted solution]

Perhaps:

Column = 
    VAR __Vessel1Value = MAXX(FILTER('Table',[Vessel Number] = 1 && [Production Date] = EARLIER('Table'[Production Date])),[Production])
    VAR __Count = COUNTROWS(FILTER('Table',[Vessel Number] <> 1 && [Production Date] = EARLIER('Table'[Production Date])))
RETURN
    [Production] - __Vessel1Value / __Count

[jaymetbar]

amazing. Thanks so much!