Return the value from the next matching row

[Anonymous]

Hi Experts,

I have a table of callers and I want to be able to add a new column which shows the next time they called.

so I have columns

DateTime | Customer ID | Session ID |

I want to add a new column of "Called Back" which will look down for the next row that matches the Customer ID and then enter the Session ID so I can look up that call.

I'm struggling to find a solution for this, so any help would be great.

[v-chuncz-msft]

@Anonymous,

You may refer to the post below and change the code accordingly.

https://community.powerbi.com/t5/Desktop/Finding-the-previos-occurrence-within-same-table-based-on-one/m-p/342607#M153516

[Anonymous · Accepted solution]

Cheers,

I actually found a solution by using power pivot. Filter, sort, then add and index column from 0 and an index column from 1 and join to itself. And then an if statement for if the customers match.