Forum Discussion
Power Query INDEX Column
INDEX is applied to the table returned on previos step (by default). If on previous is filtered table, index will be applied to it. It can't be empty cell here, INDEX applies exactly as many indexes as we have rows in the table.
If you add INDEX before filtering it some indexes dissaper together with filtered rows.
However, I didn't catch how you receive such result. If you query the table with 8300 rows, transform it by filterenig into the table with 6207 rows and load result into the grid as another table, in that resulting table shall be exactly 6207 rows without any blanks.
INDEX is applied to the table returned on previos step (by default). If on previous is filtered table, index will be applied to it. It can't be empty cell here, INDEX applies exactly as many indexes as we have rows in the table.
If you add INDEX before filtering it some indexes dissaper together with filtered rows.
However, I didn't catch how you receive such result. If you query the table with 8300 rows, transform it by filterenig into the table with 6207 rows and load result into the grid as another table, in that resulting table shall be exactly 6207 rows without any blanks.
Your response prompted me to re-check my Table and I found that Rows 6208-8300 were not formatted as part of the Table. So, I resized the table so it would capture those as well.
Unfortunately, I just assumed my Table included all items. Rookie mistake on my part. Thanks for the swift response.
