Measure using the outcome of a measure

[Moharfaoui]

Hi guys, 

I'm new to this community. Thank your for the helpo in advance. 

So I am trying to calculate the volatitlity of the Sotck Exchange 

1) I have a table with the dates and the Stock Close Price.

2) From that point I did a measure so I can have the return for each date. 

Return =

VAR currDate =

MAX ( 'Stock Data'[Date] )

VAR prevDate =

CALCULATE (

MAX ( 'Stock Data'[Date] ),

FILTER ( ALLSELECTED ( 'Stock Data' ), [Date] < currDate && [Close]<> BLANK () ),

VALUES ( 'Stock Data'[Quote Symbol] )

)

VAR prevAmount =

CALCULATE (

SUM ( 'Stock Data'[Close] ),

FILTER ( ALLSELECTED ( 'Stock Data' ), [Date] = prevDate ),

VALUES ( 'Stock Data'[Quote Symbol] )

)

RETURN

DIVIDE ( SUM ( 'Stock Data'[Close] ) - prevAmount, prevAmount )

This measure code worked fine. 

3) Now, I want to have a measure that calculates the standard deviation for each date for the last returns (outcome of the measure Return). The problem is that STDEVX.S() needs a column (I'm trying to avoid a calculated columns). 

I hope I explained the proble that I face. If you need more details, just let me know. 

Regards. 

[tamerj1]

@Moharfaoui 

Try

STDEVX.S ( VALUES ( Date[Date] ), [Return] )

[Moharfaoui]

Hi, 

Thank you for your replay. 

It's working but that not what I'm looking for. (This only calculate the standar deviation for the whole serie and doesn't iterate). 

I need to calculate de standar deviation up to date for each date. I leave this table as an example.

DATE	QUOTE SYMBOL	CLOSE	RETURN	Volatility
....	....	....	...	...
01/09/2019	AAPL	152.00	1.00%	4,12%
02/09/2019	AAPL	158.00	3.94%	4,1%
03/09/2019	AAPL	159.00	0.63%	4,09%

Thank you again. I hope I explain it well. 

[tamerj1 · Accepted solution]

@Moharfaoui 

Try

STDEVX.S ( CALCULATETABLE (VALUES ( Date[Date] ), Date[Date] <= MAX (Date[Date])), [Return] )