Forum Discussion

ChipTz's avatar
ChipTz
Frequent Visitor
6 years ago
Solved

Time stamp to event UUID

Hi, I have the following two example tables in my data:   EVENTS TimeStamp Node 01/10/2019 11:23 A 01/10/2019 12:43 A 01/10/2019 12:55 B 01/10/2019 16:23 A 02/10/2019 09:2...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    ChipTz try this and check if it works for you

    Column = CALCULATE(MIN(Check[UUID]),FILTER(Check,Check[ENDDATE]>=Event[TimeStamp] && Check[Node]=Event[Node]))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

ChipTz try this and check if it works for you

Column = CALCULATE(MIN(Check[UUID]),FILTER(Check,Check[ENDDATE]>=Event[TimeStamp] && Check[Node]=Event[Node]))
ChipTz's avatar
ChipTz
Frequent Visitor
6 years ago

Thanks for the fast feedback. It did work on the example data I posted but it is not working on my real data. I need to check what is wrong wiht my data 😐

 

I don't get why MIN is the function that solves this, tough. I was expecting something as SELECTEDVALUE.