Max Value for Score of Same Date

Question

Hi,&nbsp;I have a table that contains a DATE &amp; 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:DATEScore&nbsp;Expected Result: Max Score for Date4/1/202310404/1/202320404/1/202330404/1/202340405/9/2023225/10/2023155/10/2023555/11/2023665/12/2023575/12/202377&nbsp;Is there a way to have this in a Calculated column and not measure?

freemanz · Answer

hi&nbsp;rogerthat&nbsp;try like:Column = 
MAXX(
    FILTER(
        data, 
        data[Date]=EARLIER(data[Date])
    ),
    data[Score]
)it worked like:

Forum Discussion

Max Value for Score of Same Date

1 Reply

Related content

Calculating Score Difference between oldest and newest score

Bradley Terry score representation - visuels?

Display value with highest average score

Fuzzy Merge - similarity score

DAX average score

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