cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBIMorgan01 Frequent Visitor
Frequent 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 Frequent Visitor
Frequent Visitor

Max with calculated value

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

Community Support Team
Community Support Team

Re: Max from calcul

@PBIMorgan01 ,

 

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

 

Regards,

Jimmy Tao

PBIMorgan01 Frequent Visitor
Frequent Visitor

Re: Max from calcul

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.

saykasku Regular Visitor
Regular Visitor

Re: Max from calcul

Please add [ANombre Equipement Down] calculation.

Community Support Team
Community Support Team

Re: Max from calcul

@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

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 359 members 3,253 guests
Please welcome our newest community members: