Formula is giving blank values?

[Kaitlyn2004]

I'm trying to work on my own investment tracking spreadsheet, and trying to learn from the PortfolioSlicer workbook.

I'm trying to get the "Equity Value" which is this calculated field:

=ROUND(
   CALCULATE(
		SUMX(tblSymbols
			, tblReport[Qty Held] 
			  * CALCULATE(VALUES(Quotes[Close])
					, LASTNONBLANK(
						DATESBETWEEN(Dates[Date], DateAdd(LastDate(Dates[Date]), -40, day), MAX(Dates[Date]))
					  , CALCULATE(COUNT(Quotes[Close]) )) 


				)
		)
		, LASTDATE(Dates[Date]), All(Dates)
  )
, 2)

However it's just giving blank values. If I change it to this:

=ROUND(
   CALCULATE(
		SUMX(tblSymbols
			, tblReport[Qty Held] 
			  * 2
		)
		, LASTDATE(Dates[Date]), All(Dates)
  )
, 2)

Then I am in fact getting the Qty Held * 2 showing up.

Anyone have any insights as to why the inner formula is failing/returning blank values? Been pulling my hair out here

If I create a 2nd calculated field:

=LASTNONBLANK(
                        VALUES(Dates[Date])
                      , CALCULATE(COUNT(Quotes[Close])))

I am in fact getting the correct last row/last date I have for that specific symbol

 

[HillDragon]

CALCULATE(VALUES(Quotes[Close]) 					, LASTNONBLANK( 						DATESBETWEEN(Dates[Date], DateAdd(LastDate(Dates[Date]), -40, day), MAX(Dates[Date])) 					  , CALCULATE(COUNT(Quotes[Close]) ))

When you test this in a separate calculated filed is it returning the desired number?
If not, have you tried messing with the combination of LASTDATE() + MAX() that you have in the DATESBETWEEN()? I know LASTDATE() returns a single column, single row table while MAX() returns a value. Maybe that is causing some issues?

Anyway, if you could post some sample data we may be able to figure something out.</pre>