Display maximum value from 4 collums

[petrkos]

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

Max of more than 2 columns Measure =
MAXX(
    {
        MAX('Sheet1'[1.]),
        MAX('Sheet1'[2.]),
        MAX('Sheet1'[3.]),
        MAX('Sheet1'[4.])
       },
    [Value]
)

also i would like display it in some graphic where maximum is 500. for example check screen.

thanks

[v-henryk-mstf]

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.

[petrkos]

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