Customer next step

Question

Hi all,My data look like below&nbsp;&nbsp;CustomerId&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; START&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;END&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JOURNEY_STATE&nbsp; &nbsp;1111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020-01-02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-01-02 22:16:23.000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020-01-02 22:19:02.000&nbsp; &nbsp; &nbsp; &nbsp; Arrival&nbsp; &nbsp;1111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020-01-02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2020-01-02 22:19:03.000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-01-02 22:23:17.000&nbsp; &nbsp; &nbsp; &nbsp; Enquiry&nbsp; &nbsp; 2222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020-01-02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-01-02 15:48:21.000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020-01-02 15:49:09.000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Arrival&nbsp; &nbsp; 2222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020-01-02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020-01-02 15:49:10.000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-01-02 15:52:28.000&nbsp; &nbsp; &nbsp; &nbsp;Navigation1Count of each unique customer who is in the "Arrival" step and reached to "Navigation1"&nbsp;The count should be based on a two-point relationship that showcases the customers who convert from "Arrival" to "Navigation1" as a direct link/flow my data set is very large its nearly 2CR&nbsp;the count I need is =1&nbsp;

amitchandak · Answer

manideep547 , Can you share this data with the expected output? Let me check again
&nbsp;

amitchandak · Answer

The information you have provided is not making the problem clear to me. Can you please explain with an example and better dataAppreciate your Kudos.
&nbsp;

manideep547 · Answer

amitchandak&nbsp; Here 2222 customer&nbsp; from Arrival&nbsp; (2020-01-02 15:49:09.000 &nbsp;session end previous record ) directly converted to&nbsp; in Navigation1(2020-01-02 15:49:10.000 ,session start next record)count number of customers converted from arrival to Navigation1 =1Thanks for your reply&nbsp;&nbsp;

manideep547 · Answer

@amitchandak&nbsp; My dataCustomerId&nbsp; &nbsp;DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; START&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;END&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;JOURNEY_STATE&nbsp;1111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-01-02&nbsp; &nbsp; &nbsp; 2020-01-02 22:16:23.000&nbsp; &nbsp; 2020-01-02 22:19:02.000&nbsp; &nbsp; &nbsp;Arrival&nbsp;1111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020-01-02&nbsp; &nbsp; &nbsp; 2020-01-02 22:19:03.000&nbsp; &nbsp; &nbsp; 2020-01-02 22:23:17.000&nbsp; &nbsp; &nbsp; Enquiry&nbsp; 2222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020-01-02&nbsp; &nbsp; &nbsp;2020-01-02 15:48:21.000&nbsp; &nbsp; &nbsp; &nbsp;2020-01-02 15:49:09.000&nbsp; &nbsp; &nbsp; Arrival&nbsp; 2222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020-01-02&nbsp; &nbsp; &nbsp; 2020-01-02 15:49:10.000&nbsp; &nbsp; &nbsp; &nbsp;2020-01-02 15:52:28.000&nbsp; &nbsp; &nbsp;Navigation1&nbsp;

amitchandak · Answer

manideep547&nbsp;
I create a new column like :
&nbsp;
Is nav = if(ISBLANK( MiNX(FILTER(journey,journey[START]&gt;EARLIER(journey[end]) &amp;&amp; journey[CustomerId]=EARLIER(journey[CustomerId]) &amp;&amp; journey[JOURNEY_STATE] = "Navigation1"),journey[START])),"No","Yes")
&nbsp;
&nbsp;
You can modify as per need
File is attached below signature . if you need more help make me @Appreciate your Kudos.
&nbsp;

Forum Discussion

Customer next step

8 Replies

Related content

Custom Stepped Layout??

Rename applied step in Power Query without waiting for step to refresh

Stepped Layout Option Missing

Multiple steps Power Query custom function

Custom Column Causes "Query references other queries or steps" error