Choosing rows and undo error

[parthkwatra17]

Hey, How do i go back to the steps orgininally done before the error was made and, 
Is there any way I can select rows, like I selected columns? 

Please help! 

[Omid_Motamedise]

@MFelix  right, you can add the name for this step, but if you whant to emove this step completely, make sure you hace remved the "," sign from the ned of the previous step.

In power query last step do not need "," at the end

[mussaenda]

Hi @parthkwatra17 , 

@MFelix  is right. Have you tried to do his suggestion? What is the showing after you did his suggestion?

[MFelix · Accepted solution]

Hi @parthkwatra17 ,

The problem is that you have added one step without giving it a name so you need to remove the line  below

Concerning the selection part what you need to do is to do a filter condition so in this case would be something similar to:

= Table.SelectRows (#"Removed Other Columns",each [ColumName] = "Personal" or [ColumnName] = "Cash")

Replace the ColumnName by the column where you are filtering those values

So the last two lines of you query can be replaced by:

STEPNAME = Table.SelectRows (#"Removed Other Columns",each [ColumName] = "Personal" or [ColumnName] = "Cash")
in
STEPNAME

Change the STEPNAME by whatever text you want be carefull if you want to have spaces it needs to be like #"This is my step name"

[parthkwatra17]

hey, thanks for getting back. 

I am still facing a little issue. Would it be possible to connect over a quick call? 

[MFelix]

Hi @mussaenda ,

Please connect trough private message with contact information.