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

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] )
    )
)

Greg_Deckler

Community Champion

4 years ago

Begbie Seems like Lookup Min/Max like:

Lookup Max Simple = 
    VAR __Table = 'Table'
    VAR __Max = MAXX(__Table,[EvaluatedAt])
RETURN
    MAXX(FILTER(__Table,[EvaluatedAt] = __Max),[IsCapabilityActivated])

You likely need to add some additional filtering criteria, etc. but I'm not sure how you are using or want to use your measure/column.

Begbie

Helper I

4 years ago

Many thanks for the reply and just tried what you suggested, but returns the error The function MAXX cannot with the values of type Boolean 😔

Forum Discussion

Returning a value from most recent date