Error using Max on date within a Calculate

[ilcaa72]

i am trying to return a value based on the maximum date the calculation i am using is...

max date = CALCULATE( SUM(test[MatchedRate]), max(test[Date]))

my error message is "A function MAX has been used in a True/False expression that is used as a table filter expression. this is not allowed".

[Anonymous · Accepted solution]

To get the value on the most recent date use the following.

Latest by Date =
CALCULATE (
    SUM(test[MatchedRate]),
    FILTER (
        ALL ( test),
        test[Date] = MAX ( test[Date] )
    )
)

If you have multiple items on the last day though it will sum them all. If you just want one line item then you need an chronological Id/Index field.

Latest by Index =
CALCULATE (
    SUM(test[MatchedRate]),
    FILTER (
        ALL ( test),
        test[Index] = MAX ( test[Index] )
    )
)