Having a wierd issue I hope someone can explain, trying to perform a "self join" in Power Query with a duplicate table to find the next event in a series of events.
Data looks like this:
I can merge the duplicate table ok and the table preview shows the correct data like so:
Note that the next event for this object after "Doctor Seen" is "Bed Request"
The issue is that when I click Expand on the column the data swaps around! In this example when I click expand Doctor Seen moves to Index postion 6 and Departure Time moves to position 2 and joins to Bed Request.
I have tried:
Self Joining to the table itself.. same issue
comepletely rebuilding the tables from scratch with new spreadsheet... same issue
copying the data into embedded (Enter Data) tables and the join -> expand.. this works correctly??