Forum Discussion
dearwatson
Continued Contributor
Continued ContributorTable Expand issue
Hi Folks, 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 th...
dearwatson
I checked and found the culprit; it seems to be the sort that doesn't retain the status, joins change order. Wrap yourSorted Rows step in Events Table as
Table.Buffer(Table.Sort(#"Renamed Columns",{{"atd_id", Order.Descending}, {"Value", Order.Ascending}}))
Before Expand
Same after Expand________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
Fowmy
Super User
Super Userdearwatson
I checked and found the culprit; it seems to be the sort that doesn't retain the status, joins change order. Wrap your
Sorted Rows step in Events Table as
Table.Buffer(Table.Sort(#"Renamed Columns",{{"atd_id", Order.Descending}, {"Value", Order.Ascending}}))
Before Expand
Same after Expand
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂