nth Instance in Power Query to count pageviews by session

[nckpedersen]

I am trying to extrapolite user site flow using a pageview report that has unique session id, visit date/time, url, and referrer url. 

I'd like to sort by chronological (ascending) on the date column, then duplicate the table, remove all columns but session id, remove duplicates, assign an index value. Then merge that table with original, sort by index value, then count instance of that index value. 

I need a formula like =countif(A$1:A1)

[OliT]

Hi @nckpedersen 

>> I'd like to sort by chronological (ascending) on the date column, then duplicate the table, remove all columns but session id, remove duplicates, assign an index value. Then merge that table with original, sort by index value, then count instance of that index value. 

So where are you stuck now? What do you need us to help you with?  If possible, please share a sample process diagram and your sample data.

Regards,

OliT

[Ashish_Mathur]

Hi,

Imke's solution here will answer your question - Solved: Custom column Index or Ranking by other column.

[lbendlin]

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.