Max from calcul

[PBIMorgan01]

Hello,

I have calculated a number device down on specific date and time

I have a Event table with down and up events and a Node table (with actual down). And another calendar and time table.

I calculate : Actual down - eventdown + event up

If I use a graphic, no problem, I have number by day and time. 

But, I would like, for example select 30/07 and know haw many device is down. With a card I have a number but I would like to have a max value.

How can I have a max from a calculate (my values are calculated and not are in column) ? Or get value according to the date ?

Thanks for your help

[PBIMorgan01]

Hello,

I have calculated a number device down on specific date and time

I have a Event table with down and up events and a Node table (with actual down). And another calendar and time table.

I calculate : Actual down - sommeeventdown + somme event up

If I use a graphic, no problem, I have number by day and time. 

But, I would like, for example select 29/07 and know haw many device is down. With a card I have a number but I would like to have a max value (104)

How can I have a max from a calculate (my values are calculated and not are in column) ? Or get value according to the date ?

Here an example :

Thanks for your help

[v-yuta-msft]

@PBIMorgan01 ,

Could you please share some dummy data and share more details about the expected result?

Regards,

Jimmy Tao

[PBIMorgan01]

Hello,

I calculate number for each date :

ANombre Equipement Down is a measure

EventTime is a EventTime in table

ANombre Equipement Down	EventTime
104	27/7/19 14:07
100	27/7/19 14:14
99	27/7/19 14:15
100	27/7/19 14:15
100	27/7/19 14:15
100	27/7/19 14:15
100	27/7/19 14:16
100	27/7/19 14:16
100	27/7/19 14:16
100	27/7/19 14:16
98	27/7/19 14:16
97	27/7/19 14:16
98	27/7/19 14:16
85	27/7/19 14:16
99	27/7/19 14:16
99	27/7/19 14:16
100	27/7/19 14:16
100	27/7/19 14:17
100	27/7/19 14:18
100	27/7/19 14:18
100	27/7/19 14:18
100	27/7/19 14:18
100	27/7/19 14:19
99	27/7/19 14:19
99	27/7/19 14:19
100	27/7/19 14:19
100	27/7/19 14:20
99	27/7/19 14:20
100	27/7/19 14:21
97	27/7/19 14:21
99	27/7/19 14:21
100	27/7/19 14:23
100	27/7/19 14:26
100	27/7/19 14:26
100	27/7/19 14:26
100	27/7/19 14:26
89	27/7/19 14:27
100	27/7/19 14:27
99	27/7/19 14:28
100	27/7/19 14:28
100	27/7/19 14:29
100	27/7/19 14:29
99	27/7/19 14:29
100	27/7/19 14:31
100	27/7/19 14:31
100	27/7/19 14:31
100	27/7/19 14:31
99	27/7/19 14:32
100	27/7/19 14:33
100	27/7/19 14:33
100	27/7/19 14:34
98	27/7/19 14:34
100	27/7/19 14:36
100	27/7/19 14:36
100	27/7/19 14:36
99	27/7/19 14:37
100	27/7/19 14:38
100	27/7/19 14:38
100	27/7/19 14:39
98	27/7/19 14:39
99	27/7/19 14:39
100	27/7/19 14:41
100	27/7/19 14:41
99	27/7/19 14:42
100	27/7/19 14:43
100	27/7/19 14:43
100	27/7/19 14:44
100	27/7/19 14:44
100	27/7/19 14:44
94	27/7/19 14:44
99	27/7/19 14:44
100	27/7/19 14:48
100	27/7/19 14:48
100	27/7/19 14:48
100	27/7/19 14:49
100	27/7/19 14:49
99	27/7/19 14:49
100	27/7/19 14:51
100	27/7/19 14:53
100	27/7/19 14:53
100	27/7/19 14:53
102	27/7/19 14:53
100	27/7/19 14:53
100	27/7/19 14:54
100	27/7/19 14:54
100	27/7/19 14:54
99	27/7/19 14:54
98	27/7/19 14:54
101	27/7/19 14:54
100	27/7/19 14:55
99	27/7/19 14:55
98	27/7/19 14:55
100	27/7/19 14:55
100	27/7/19 14:55
98	27/7/19 14:56
90	27/7/19 14:56
100	27/7/19 14:56
100	27/7/19 14:56
100	27/7/19 14:57
99	27/7/19 14:57
96	27/7/19 14:58
100	27/7/19 14:58
101	27/7/19 14:58
99	27/7/19 14:59

I would like to have the max value (for example 27/07 2PM)

If I use a card, I have 23.

I can't using max function because it is not a column but a measure.

So, I would like in card the max value from my table.

[v-yuta-msft]

@PBIMorgan01 ,

"

I would like to have the max value (for example 27/07 2PM)

If I use a card, I have 23.

"

<-- Could you clarify why the max value is 27/07 2PM and how can we acheve 23?

Regards,

Jimmy Tao

[saykasku]

Please add [ANombre Equipement Down] calculation.