find date and day name related to a max value

[Anonymous]

Hello All,

I need help creating a dax measure to the date related to Max head count. I can use the max function to get the max value but not quite sure how to get the date and the day name related to that max head count.

Please find the raw data table and the output below.

Any help is greatly appreciated.

Thanks,

Deevs

[amitchandak · Accepted solution]

@Anonymous , for date name and day, try these two measures

lastnonblankvalue(table[headcount]), max(Table[Date]))
lastnonblankvalue(table[headcount]), max(Table[Day Name]))

And take the game name and head count as not summarized . or max for head count

[Anonymous]

@amitchandak   One more question .. how do you handle if there are more than one max head count? 

[Anonymous]

You are a Legend Amit 🙂

[lbendlin]

what if you have multiple days with the same maximum headcount? How are you planning to break the tie?

[Anonymous]

....