Forum Discussion

Begbie's avatar
Begbie
Icon for Helper I rankHelper I
4 years ago
Solved

Returning a value from most recent date

Hi All,   Seems to be going round in circles here and I'm sure the expression I'm using isn't quite right to achieve what I am after. I have the below data set:     What I am trying to ach...
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    It looks like you're pretty close with your measure.

     

    Does tweaking it like this give you what you expect?

    Is Beacon Activated =
CALCULATE (
    SELECTEDVALUE ( BeaconHistory[IsCapabilityActivated] ),
    FILTER (
        BeaconHistory,
        BeaconHistory[EvaluatedAt] = MAX ( BeaconHistory[EvaluatedAt] )
    )
)
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

It looks like you're pretty close with your measure.

 

Does tweaking it like this give you what you expect?

Is Beacon Activated =
CALCULATE (
    SELECTEDVALUE ( BeaconHistory[IsCapabilityActivated] ),
    FILTER (
        BeaconHistory,
        BeaconHistory[EvaluatedAt] = MAX ( BeaconHistory[EvaluatedAt] )
    )
)
  • Begbie's avatar
    Begbie
    Icon for Helper I rankHelper I
    4 years ago

    😍

     

    That only seems to only gone and done it. 

     

    From one Alexis to another Alexis, thank you very much!!