I have a table with timestamps and unique ids. What i am trying to achieve is:
For each row, look at previous 30 minutes and return "Yes" if there was same Id.
Is there a way to achieve something like this?
Table below shows an example (Not sure if table is 30 minutes, as i took random numbers)
Go to Solution.
Hi @filarap ,
To create two calculated column as below.
FILTER ( 'Table', 'Table'[ID] = EARLIER ( 'Table'[ID] ) ),
VAR inx = 'Table'[index] - 1
VAR a =
MAX ( 'Table'[Time Stamp] ),
'Table'[index] = inx
&& 'Table'[ID] = EARLIER ( 'Table'[ID] )
VAR b = 'Table'[Time Stamp]
VAR diff =
DATEDIFF ( a, b, MINUTE )
IF ( ISBLANK ( diff ) || diff > 30, "no", IF ( diff <= 30, "yes" ) )
View solution in original post
Thank you v-frfei-msft
Realy great solution, work like a charm.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!