Need an expression to return the date and hour of each peak value

[CMccown]

I have a DAX measure to return a peak hourly value in a table called System_Load:

Peak System Load = MAX(System_Load [Hr Sys Load])

I can build the following table with this expression - this represents the peak value for each month with the year filter applied:

I need to be able to calculate the corresponding date and hour that these values occurred to be able to build a table similar to this:

My raw data table looks like the following:

Your assistance is greatly appreciated!

[CMccown]

@nick_potts, I am able to create a matrix visual for the table itself but I do need a measure to return the individual dates to use as a basis for graphs in a separate data table and haven't quite wrapped my head around that. Any help is appreciated.

[bolfri]

Just pase here a values from that table so we can copy it 😉 Sample data needed.

[nick_potts]

This looks like it'll be a matrix visual with the hour as your row then date and day of week as your columns. You might even be able to drop that previous measure for peak load as your value. It should use context to filter down to the hour and date. You'll need to make a day of week column on that table using the date field 

[bolfri]

Can you share a PBIX file with sample data or a table so everyone can copy and paste it? 🙂