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] )
    )
)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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's avatar
    Begbie
    Icon for Helper I rankHelper 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 ğŸ˜”