Calculate the Duraction between event

[Anonymous]

Hi,

I need some help, I have the set of data look like below, what I am trying to do is calculate the connection time.

when the connection trigger, it will crate a event with the event code "201" and if it successfully connectd it will create another event with event code "202" but if it failed, the event "202" won't show up. 

What I am trying to achieve is in this logic:

Run through the data set, when there is a event code "201" but if there is no "202"  for the same source name(the source name is the client workstation ID that try to connect) move on, if there is 201 after the 202 from the same source name, put the duration between the 201 and 202 beside the 202.

Thank you for all your help in advance!

[v-chuncz-msft]

@Anonymous,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Array-formulae-in-Power-BI-for-IF-and-MAX-functions/m-p/441637#M203966