Identify Value based on Minimum date

[Vinod_G_245]

Hi Team,

Please find the attached image and help me with the Dax.

Vinod G

[v-xinruzhu-msft]

Hi @Vinod_G_245 

You can refer to the following measure

Base Price =
VAR _min =
    MINX ( ALLSELECTED ( 'Table' ), [Date] )
RETURN
    SUMX ( FILTER ( ALLSELECTED ( 'Table' ), [Date] = _min ), [Actual Price] )

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vinod_G_245]

@amitchandak , @DOLEARY85 , @lbendlin 

Requesting you all please have a look at requirement and provide your inputs.

Thanks, 

Vinod G