Get latest Time

[stefan321]

HI everyone,

hope someone can help me 🙂

I have the following Table.  What i am aiming for is to have the latest "Time" where a Server was "Online".
The Table contains different Servers with different Status and Time. For example, i want to have for Server A the Time "Wed, 20 Mar 2024 15:51:17" as it is the alst online Time.

i would show that "latest online" with dropdown menu or a checkbox. How is that possible?

Servername	Status	Time
Server A	Online	Wed, 20 Mar 2024 15:51:17
Server A	Online	Mon, 18 Mar 2024 15:50:51
Server A	Offline	Wed, 13 Mar 2024 15:52:59
Server B	Online	Wed, 06 Mar 2024 15:50:14
Server B	Online	Mon, 04 Mar 2024 15:58:29
Server B	Online	Mon, 04 Mar 2024 15:58:29

[some_bih]

Hi @stefan321 in your simplify example, it is possible to use "Latest" when you put data into matrix

[stefan321]

HI 
thanks, but it should only show latest for server with status "Online"
Is it possobie with a measure / DAX query ?

[QuentinBl]

You can try to create a measure like this : measure = CALCULATE(MAX(time), Status = "Online")

Or

If you only want the status "online" in your visual, you can add filtre in the filter panel with the column "status" and the value "online"

[stefan321]

HI

Thinkmore logic is needed here. Please consider that i have in that table different Servers like "Server A" or "Server B". i need the last time (Time column) when server was online (Status column) from EACH Server. 
Example:

Server A --> 20 Mar 2024 15:51:17 (last online date)
Server B --> 06 Mar 2024 15:50:14 (last online date)