How to get range end close price for month duration based in id

[ghost10]

Hi,

I have some samples where I am trying to get the end close price values.

Please help me in creating measure to derive third  last(Range end close price) column.

 

[v-chenwuz-msft · Accepted solution]

Hi @ghost10 ,

Try some dax code like this:

last price =
VAR _maxdate =
    CALCULATE (
        MAX ( 'Table'[Trade Date] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            [based id] = SELECTEDVALUE ( 'Table'[based id] )
        )
    )
RETURN
    CALCULATE (
        MAX ( 'Table'[Range end close price] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            [based id] = SELECTEDVALUE ( 'Table'[based id] )
                && [Trade Date] = _maxdate
        )
    )

Best Regards

Community Support Team _ chenwu zhu

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