Power Query - Filtering After Table Loads, with extra columns

[jaihawk8]

I have a table from Power Query that is loading certain information from a Salesforce.com Report. I have added extra columns (after it loads) to do a VLOOKUP against another set of data in the file. That information returns fine, but if I try to put filters on the top row for everything, it doesn't let me filter any of the data. What am I doing wrong?

 

[johnny51981]

Your Auto Filter on the table and the Auto Filter on the added columns are, essentially 2 different and unrelated things. Formulas tend to get wonky sometimes when you try to associate formulas -for a table- but -outside of a table- .

If you have extra data that you incorporate via a VLOOKUP, are you not able to build that data into your Power Query and merge it in with the Salesforce Data rather than recreating parts of the wheel each time?

If not, what I tend to do is resize the table to include the columns that I am looking to add, and then do the formulas within that.