Forum Discussion
Display maximum value from 4 collums
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 |