Bring in custom column in new query

[TO3]

Hi Community,

I'm stuck and am a newbie to Power Query. I've been digging in the WWW, but to no avail so hoping I can pick your brains.

In table A, I have added a custom column with an if statement, the column header is called Amounts as well as the applied step. I have created a 'new blank query' and am trying to bring in various columns from table A with including the custom column, by using the below query

#"table A"[[Date],[Name],[custom column]] this errors out when trying to bring in the custom column, however if I remove the custom #"table A"[[Date],[Name]] it brings the called columns.

The Amounts column is value format, there are no errors or null values in that column, reference to column header text is exact. 

Really appreciate your help, Thanks

[TO3]

Thank you for coming back Dufoq3, still doesn't work. My error says the column doesn't exist strangely. However, I just cloned the table and deleted the rest of the columns

[v-xinruzhu-msft]

Hi,

Thanks for the solution @dufoq3  provided, and i want to offer some more information for user to refer to.

hello @TO3  you can try the following code.

let
    a = Table.SelectColumns(#"table A",{"Date","Name", "Amounts"})
in
    a

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dufoq3]

Power Query is case sensitive so be careful because "table A" <> "Table A" and "custom column" <> "Custom Column" etc...

[dufoq3]

Hi, it should work. In new query you can just refer to table a so Source = #"table A" and then select columns you want, right click and REMOVE OTHER COLUMNS or you can try

Source = Table.SelectColumns(#"table A", {"Date","Name", "custom column"})