Latest "Yes" based on timestamp

[Jeffrey_VC]

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 · Accepted solution]

Hi, @Jeffrey_VC 

try below

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

[Dangar332]

Hi, @Jeffrey_VC 

try below code

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

[Jeffrey_VC]

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 · Accepted solution]

Hi, @Jeffrey_VC 

try below

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

[Jeffrey_VC · Accepted solution]

Works! Thnx.