Forum Discussion
Display maximum value from 4 collums
Hi, i would like ask your for help
data looks like this
I would like graphic display quarter of hourly maximum electriccity consumption, but i have problem that its not show me correct.
sometimes its good and sometimes is wrong. check the screens.
i used this measure code
MAXX(
{
MAX('Sheet1'[1.]),
MAX('Sheet1'[2.]),
MAX('Sheet1'[3.]),
MAX('Sheet1'[4.])
},
[Value]
)
2 Replies
Hi petrkos ,
My test return correct answer, try formula like below:
Measure:
Result_M = MAXX ( { MAX ( 'Table'[Value1] ), MAX ( 'Table'[Value2] ), MAX ( 'Table'[Value3] ), MAX ( 'Table'[Value4] ) }, [Value] )Calculated column:
Result = MAXX ( { 'Table'[Value1], 'Table'[Value2], 'Table'[Value3], 'Table'[Value4] }, [Value] )If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi,
sorry for late answer i was very bussy
i will describe my problem more
Data table contain maximum electriccity consumption every 15 minutes per hour. (1,2,3,4) the last column is average consumption per hour. this measure repeat all day.
So what i want:
I want show data for every hour with average value, and after click on certein hour i want display the maximum consumption.
table for example:
1/4 of hour/
Day hour:1. 2. 3. 4. AVG
[kWh]00 - 01 70 76 74 76 74 01 - 02 78 74 74 74 75 02 - 03 72 74 74 72 73 03 - 04 74 72 72 72 73 04 - 05 72 70 72 70 71 05 - 06 70 72 70 72 71 06 - 07 70 74 74 72 73 07 - 08 72 68 72 72 71 08 - 09 72 72 70 70 71 09 - 10 70 66 70 72 70 10 - 11 74 72 72 72 73 11 - 12 70 70 68 72 70 12 - 13 74 72 72 76 74 13 - 14 74 74 122 222 123 14 - 15 180 118 116 120 134 15 - 16 82 106 94 84 92 16 - 17 82 80 82 82 82 17 - 18 74 76 74 74 75 18 - 19 72 74 80 74 75 19 - 20 78 72 78 80 77 20 - 21 76 82 78 78 79 21 - 22 78 78 74 78 77 22 - 23 74 78 76 72 75 23 - 00 72 74 74 76 74
