topic Re: Get latest Time in DAX Commands and Tips

Get latest Time

stefan321 — Tue, 26 Mar 2024 10:39:15 GMT

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

Re: Get latest Time

some_bih — Tue, 26 Mar 2024 11:48:57 GMT

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

Re: Get latest Time

stefan321 — Tue, 26 Mar 2024 12:21:31 GMT

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

Re: Get latest Time

Anonymous — Tue, 26 Mar 2024 13:02:06 GMT

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"

Re: Get latest Time

stefan321 — Thu, 28 Mar 2024 11:22:00 GMT

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)