Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PBIMorgan01
Regular Visitor

Max from calcul

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

5 REPLIES 5
PBIMorgan01
Regular Visitor

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 :

 

Capture_max.PNG

Thanks for your help

v-yuta-msft
Community Support
Community Support

@PBIMorgan01 ,

 

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

 

Regards,

Jimmy Tao

Hello,

 

I calculate number for each date :

ANombre Equipement Down is a measure

EventTime is a EventTime in table

ANombre Equipement DownEventTime
10427/7/19 14:07
10027/7/19 14:14
9927/7/19 14:15
10027/7/19 14:15
10027/7/19 14:15
10027/7/19 14:15
10027/7/19 14:16
10027/7/19 14:16
10027/7/19 14:16
10027/7/19 14:16
9827/7/19 14:16
9727/7/19 14:16
9827/7/19 14:16
8527/7/19 14:16
9927/7/19 14:16
9927/7/19 14:16
10027/7/19 14:16
10027/7/19 14:17
10027/7/19 14:18
10027/7/19 14:18
10027/7/19 14:18
10027/7/19 14:18
10027/7/19 14:19
9927/7/19 14:19
9927/7/19 14:19
10027/7/19 14:19
10027/7/19 14:20
9927/7/19 14:20
10027/7/19 14:21
9727/7/19 14:21
9927/7/19 14:21
10027/7/19 14:23
10027/7/19 14:26
10027/7/19 14:26
10027/7/19 14:26
10027/7/19 14:26
8927/7/19 14:27
10027/7/19 14:27
9927/7/19 14:28
10027/7/19 14:28
10027/7/19 14:29
10027/7/19 14:29
9927/7/19 14:29
10027/7/19 14:31
10027/7/19 14:31
10027/7/19 14:31
10027/7/19 14:31
9927/7/19 14:32
10027/7/19 14:33
10027/7/19 14:33
10027/7/19 14:34
9827/7/19 14:34
10027/7/19 14:36
10027/7/19 14:36
10027/7/19 14:36
9927/7/19 14:37
10027/7/19 14:38
10027/7/19 14:38
10027/7/19 14:39
9827/7/19 14:39
9927/7/19 14:39
10027/7/19 14:41
10027/7/19 14:41
9927/7/19 14:42
10027/7/19 14:43
10027/7/19 14:43
10027/7/19 14:44
10027/7/19 14:44
10027/7/19 14:44
9427/7/19 14:44
9927/7/19 14:44
10027/7/19 14:48
10027/7/19 14:48
10027/7/19 14:48
10027/7/19 14:49
10027/7/19 14:49
9927/7/19 14:49
10027/7/19 14:51
10027/7/19 14:53
10027/7/19 14:53
10027/7/19 14:53
10227/7/19 14:53
10027/7/19 14:53
10027/7/19 14:54
10027/7/19 14:54
10027/7/19 14:54
9927/7/19 14:54
9827/7/19 14:54
10127/7/19 14:54
10027/7/19 14:55
9927/7/19 14:55
9827/7/19 14:55
10027/7/19 14:55
10027/7/19 14:55
9827/7/19 14:56
9027/7/19 14:56
10027/7/19 14:56
10027/7/19 14:56
10027/7/19 14:57
9927/7/19 14:57
9627/7/19 14:58
10027/7/19 14:58
10127/7/19 14:58
9927/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.

@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

Please add [ANombre Equipement Down] calculation.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.