Forum Discussion

stefan321's avatar
stefan321
Helper 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 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?

ServernameStatusTime
Server AOnlineWed, 20 Mar 2024 15:51:17
Server AOnlineMon, 18 Mar 2024 15:50:51
Server AOfflineWed, 13 Mar 2024 15:52:59
Server BOnlineWed, 06 Mar 2024 15:50:14
Server BOnlineMon, 04 Mar 2024 15:58:29
Server BOnlineMon, 04 Mar 2024 15:58:29

4 Replies

  • some_bih's avatar
    some_bih
    Community Champion
    2 years ago

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

     

     

     

    • stefan321's avatar
      stefan321
      Helper 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"