Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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.
Just pase here a values from that table so we can copy it 😉 Sample data needed.
Proud to be a Super User!
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
Can you share a PBIX file with sample data or a table so everyone can copy and paste it? 🙂
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |