Max Value for Score of Same Date

[rogerthat]

Hi,

I have a table that contains a DATE & Score. However, I want to be able to get the highest score [Expected Result] of that day and apply it in a seperate column as shown below:

DATE	Score	Expected Result: Max Score for Date
4/1/2023	10	40
4/1/2023	20	40
4/1/2023	30	40
4/1/2023	40	40
5/9/2023	2	2
5/10/2023	1	5
5/10/2023	5	5
5/11/2023	6	6
5/12/2023	5	7
5/12/2023	7	7

Is there a way to have this in a Calculated column and not measure?

[FreemanZ]

hi @rogerthat 

try like:

Column = 
MAXX(
    FILTER(
        data, 
        data[Date]=EARLIER(data[Date])
    ),
    data[Score]
)

it worked like: