Calculate the variance for the last value for each name

[Hayoung]

I would like to create a measure to calculate the variance of second lastest date for each Name. I have tried 

variances(lastest) =

var _1 = CALCULATE(MAX('Table'[Date]),FILTER(ALL('Table'),'Table'[Date]<CALCULATE(MAX('Table'[Date]),ALL('Table'))))

var _2 = VARX.P(FILTER('Table',[Date]=_1),[Score])

return

_2

But it is not finding last date for each Name, but finding the last date for all Name. 

sample data:

Survey ID	Name	Date	Respond ID	Score
123	A	5/9/2021	1	10
123	A	5/9/2021	2	8
123	A	5/9/2021	3	3
123	A	5/9/2021	4	0
234	B	8/9/2021	1	5
234	B	8/9/2021	2	5
234	B	8/9/2021	3	10
234	B	8/9/2021	4	0
345	A	7/9/2022	1	2
345	A	7/9/2022	2	6
345	A	7/9/2022	3	8
345	A	7/9/2022	4	3
456	B	10/9/2022	1	1
456	B	10/9/2022	2	10
456	B	10/9/2022	3	8

[tamerj1 · Accepted solution]

Hi @Hayoung 
Please replace ALL('Table') with ALLEXCEPT ( 'Table', 'Table'[Name] )