Power Query formula source table

[cmcreynolds]

Hello -

I am using a custom query I got from MS technet (and ImkeF I think answered my question there). But, I think the recent PQ updates have thrown me off (I'm on version 2.24.4064.242 by the way).

Anyway, the formula is

=Table.SelectRows(PreviousStep, each [Status] <> "D" or [LastActivity] <> null )

And my issue is the source item. I don't know how to obtain it. Is it the name of the table I'm grabbing the data? The name of the query? Specifically, is there a place I can "click" to get the correct "spelling"?

I hate 4:00 PM questions - brain dead.

Clifton

 

[Kazlik]

Can you paste all of your M code or is this all you have?

 

[cmcreynolds]

This was resolved on another forum - where it states "Previous Step" it means in the name of the step that came immediately before it, not necessarily a table. I apologize if this was obvious.