Can you filter the table when you get the data

[kintela]

Hi

I'm gettting the data form my SAP Data Base an when I select the ORDR table I know that I only want the records where the Canceled filed is N.

Can I filter this Data in this moment to work alway with this data filtered yet

regards

[Greg_Deckler · Accepted solution]

In Query Editor, select the drop down for the column and unselect "Select All" and then select "N". The M code for this is:

#"Filtered Rows" = Table.SelectRows(#"Previous Step", each ([Column] = "Value"))