I’m attempting to split a table in Excel based on rows using Power Query. Specifically, I want to create a separate table for “NON-CURRENT ASSETS”.
my data

I’ve been following a tutorial on YouTube https://www.youtube.com/watch?v=FB5Zs29A8fw&t=145s

At one point in the process, I used the following expression:

Table.SelectRows(#”Added Index”, each[2021]= null)

However, upon executing this step, I received the following error message:

Expression.Error: The name ‘Added Index’ wasn’t recognized. Make sure it’s spelled correctly.

Can someone please explain why this error occurred and suggest potential solutions to resolve it?

Thank you in advance for your assistance.