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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.