Forum Discussion

stefan321's avatar
stefan321
Icon for Helper I rankHelper I
2 years ago

Get latest Time

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 diffe...
stefan321's avatar
stefan321
Icon for Helper I rankHelper I
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    stefan321
    Icon for Helper I rankHelper I
    2 years ago

    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)