Forum Discussion

Vinod_G_245's avatar
Vinod_G_245
Helper I
3 years ago

Identify Value based on Minimum date

Hi Team, Please find the attached image and help me with the Dax. Vinod G
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.