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

4 Replies

  • 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!!

  • 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 😔