Returning a value from most recent date

[Begbie]

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 achieve is to get the latest date value, but return "IsCapabilityActivated" to be displayed. This result is then used in a table and a slicer is then used to change the option to be Secure Data, Financial Health etc.. The IsCapabilityActived is a boolean value, so seems the MAX statement cannot be used. 

Current statement I have is:

Is Beacon Activated = 
CALCULATE(SELECTEDVALUE(BeaconHistory[IsCapabilityActivated]),FILTER(BeaconHistory,MAX(BeaconHistory[EvaluatedAt])))

This isn't quite giving me the results I require. 

Any pointers would be appreciated.

Thanks.

[AlexisOlson · Accepted solution]

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]

😍

That only seems to only gone and done it. 

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

[Greg_Deckler]

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

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 😔