Get latest online Time from a Server with dropdown/checkbox

[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

[lbendlin]

That is something you can do in a table visual with standard filters and implicit measures.  What have you tried and where are you stuck?

[stefan321]

HI 

i have checked some DAX commands and measures, but i was not able to do it, i have no clue.

[lbendlin]

[stefan321]

HI

how is it possible with a measure? 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.