calculate maximum value of an hour of the day

[Syndicate_Admin]

Regards I have the following Challenge, I need to show in a table the maximum time with accesses in a day. My data is given by day, hour and number of accesses, and I only have to show by day which is the day with the hour with the greatest access:

[v-jianboli-msft · Accepted solution]

Hi @Syndicate_Admin ,

Please try:

Hour' = CALCULATE(MAX('Table'[Hour]),FILTER('Table',[Access]=MAX('Table'[Access])))

[Access] you can use the maximum aggregation directly:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.