Get values from a temporary table variable

Below is a piece of the fact table 'fTrans' that provides context to my question.

As you can see for all rows whose [Transaction] column is a "Sale" the [Days] column has empty values.

The reason being that there are cases where a "Sale" transaction relates to more than one previous "Purchase" transaction, therefore a weighted average of [Days] needs to be calculated for those "Sale" rows.

So, my goal is to write up a measure that will provide a weighted average of [Days] for every [Transaction] "Sale" rows that are currently sitting empty, and in order to get there I started with this:

EVALUATE
VAR Supp_Tbl = 
	ADDCOLUMNS( 
		SUMMARIZE( 
			fTrans, 
			fTrans[Ticker], 
			fTrans[Date], 
			fTrans[Sale date related to respective purchase], 
			fTrans[Transaction], 
			"@Days", SUMX( 
				fTrans, 
				IF( 
					fTrans[Transaction] = "Sale", 
					BLANK(), 
					INT( fTrans[Sale date related to respective purchase] - fTrans[Date] ) 
				) 
			), 
			"@PurchTotal", [Purchase total] 
		), 
		"@WghtProdDaysPurch", [@Days] * [@PurchTotal] 
	)
VAR Days_Tbl = 
	ADDCOLUMNS( 
		GROUPBY( 
			Supp_Tbl, 
			fTrans[Ticker], 
			fTrans[Sale date related to respective purchase], 
			"@SumPurchTotal", SUMX( 
				CURRENTGROUP(), 
				[@PurchTotal] 
			), 
			"@SumWghtProdDaysPurch", SUMX( 
				CURRENTGROUP(), 
				[@WghtProdDaysPurch] 
			) 
		), 
		"@WghtdAvgDays", INT( 
				DIVIDE( 
				[@SumWghtProdDaysPurch], 
				[@SumPurchTotal] 
			) 
		) 
	)
RETURN
Days_Tbl

And it returns the following temporary table VAR "Days_Tbl" whose highlighted [@WghtdAvgDays] provides said weighted average of [Days] that I need for those "Sale" transaction rows:

Now all I need is to get those values from [@WghtdAvgDays] under VAR "Days_Tbl" whenever [Sale date related to respective purchase] matches fTrans[Date] under each [Ticker].

And for that I first tried by writing the following code:

LOOKUPVALUE( 
	[@WghtdAvgDays], 
	fTrans[Sale date related to respective purchase], 
	MAXX( 
		FILTER( 
			fTrans, 
			fTrans[Ticker] = EARLIER( fTrans[Ticker] ) && 
			fTrans[Date] = EARLIER( fTrans[Date] ) && 
			fTrans[Transaction] = "Sale" 
		), 
		fTrans[Date] 
	) 
)

But it right off the bat presents two issues:

1. The column 'fTrans[Sale date related to respective purchase]' either doesn't exist or doesn't have a relationship to any table available in the current context (message given by PBI when committing the measure code).
2. [@WghtdAvgDays] can't be used as the first argument of LOOKUPVALUE as it expects a fully qualified column (message provided by DAX Studio while attempting to troubleshoot the code).

How am I supposed to get the values from the [@WghtdAvgDays] column under the temporary table VAR "Days_Tbl" then?

Thanks in advance...

P.S.:

I also tried the route of creating a third temp table with SUMMARIZECOLUMNS but it ends up aggregating the overall total of [Days] for all rows:

FILTER( 
	SUMMARIZECOLUMNS( 
		fTrans[Ticker], 
		fTrans[Date], 
		fTrans[Transaction], 
		"@Days", CALCULATE( 
			SUMX( 
				Days_Tbl, 
				[@WghtdAvgDays] 
			), 
		fTrans[Sale date related to respective purchase] = fTrans[Date] 
		) 
	), 
	fTrans[Transaction] = "Sale" 
)