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 table visualization reflecting raw data filtered by month and year with measures that determine the peak value, and the hour and date on which they occurred. Unfortunately during the month of February 2019, and December 2020 the peak value occurs twice in the same month and I want to reflect the data from Hour Ending 1 - Hour Ending 24 in the table from the correct peak date. I need assistance with either filtering my measure to account for this when finding the peak value, or by finding a way to break the tie for the TOPN filter I am using (see screen shot).
My measure to calculate the peak load is:
Assistance is greatly appreciated!
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 |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |