Forum Discussion

Jeffrey_VC's avatar
Jeffrey_VC
Helper III
2 years ago
Solved

Latest "Yes" based on timestamp

Hi everyone,

 

I'm trying to find a dax code for the latest yes based on timetamp.
Example data:

 

I need the latest "Yes". In the example "18-11-2022 11:12"

Can anyone help me?

Thanks in advance.

 

Jeffrey

  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, Jeffrey_VC 

    try below

    measure =
calculate(
  max(tablename[timestamp]),
  tablename[value]="yes",
  allexcept(tablename,tablename[timestamp]),
  tablename[deviceid]= max(tablename[deviceid])
)

4 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    Hi, Jeffrey_VC 

    try below code

    measure =
calculate(
  max(tablename[timestamp]),
  tablename[value]="yes",
  allexcept(tablename,tablename[timestamp])
)
    • Jeffrey_VC's avatar
      Jeffrey_VC
      Helper III
      2 years ago

      Thnx for your answer.

      I tried and get the latest "yes" of the total. I also have a device id.
      I need for every device id the latest "yes" 😀

      • Dangar332's avatar
        Dangar332
        Resident Rockstar
        2 years ago

        Hi, Jeffrey_VC 

        try below

        measure =
calculate(
  max(tablename[timestamp]),
  tablename[value]="yes",
  allexcept(tablename,tablename[timestamp]),
  tablename[deviceid]= max(tablename[deviceid])
)