Max Value for Score of Same Date

rogerthat — Thu, 11 May 2023 22:25:13 GMT

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?

Re: Max Value for Score of Same Date

FreemanZ — Fri, 12 May 2023 02:08:44 GMT

hi rogerthat

try like:

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

it worked like:

topic Max Value for Score of Same Date in DAX Commands and Tips

Max Value for Score of Same Date

Re: Max Value for Score of Same Date