Creating Complex DAX Formula

[Anonymous]

Hi All,

Need your help in creating DAX measure for a complex scenario. Please find data as below.

eglEnt-EntityID	End Effective Date	GrossReturn
CVIAGEQC	1/31/2022	-4.373229085
CVIAGEQC	2/28/2022	-1.376539353
CVIAGEQC	3/31/2022	-1.475548259
CVIAGEQC	4/30/2022	-6.638796952
CVIAGEQC	5/31/2022	0.55902424
CVIAGEQC	6/30/2022	-4.625465057
CVIAGEQC	7/31/2022	0.451332526
CVIAGEQC	8/31/2022	-1.650291464
CVIAGEQC	9/30/2022	-10.24389111
CVIAGEQC	10/31/2022	-2.514744465
CVIAGEQC	11/30/2022	12.46723644
CVIAGEQC	12/31/2022	0.04435882
CVIAGEQC	1/31/2023	7.708244223
CV13SMEP	10/31/2021	2.074472323
CV13SMEP	11/30/2021	-3.256589276
CV13SMEP	12/31/2021	1.769018998
CV13SMEP	1/31/2022	-6.868652896
CV13SMEP	2/28/2022	4.845474913
CV13SMEP	3/31/2022	-1.514637116
CV13SMEP	4/30/2022	0.651104627
CV13SMEP	5/31/2022	-3.72439535
CV13SMEP	6/30/2022	-7.78854253
CV13SMEP	7/31/2022	2.90686213
CV13SMEP	8/31/2022	1.827081104
CV13SMEP	9/30/2022	-5.760868735
CV13SMEP	10/31/2022	2.640674076
CV13SMEP	11/30/2022	3.016640222
CV13SMEP	12/31/2022	2.723576162
CV13SMEP	1/31/2023	2.730720733

Need to calculate E column as shown in the below screenshot for the Entity ID "CV13SMEP"

Similarly Expected result for Entity ID "CVIAGEQC"