Forum Discussion
sfog
Advocate II
Advocate IIPower Query seems to hang when I click Close and Apply
Hi I have a simple power query that sorts a column, and a step to determine when a value changes in the sorted column. This step that determines if the value changes seems to cause the query to hang...
Hi
I managed to solve it with a workaround.
My requirement was to compare the current row with the previous row - so all I did was:
- remove the line that used the index (-1) to compare to the previous row
- adding a new column (index + 1)
- merge the current query with itself (on the index and index+1 columns)
sfogAdvocate II
Advocate IIHi
I managed to solve it with a workaround.
My requirement was to compare the current row with the previous row - so all I did was:
- remove the line that used the index (-1) to compare to the previous row
- adding a new column (index + 1)
- merge the current query with itself (on the index and index+1 columns)
