Forum Discussion
New Columns Not Appearing in Query Editor, recreating formula in Query Editor is giving an error
I've read that there are issues when bringing in new columns to query editor so I am trying to recreate the column from within the query editor using the same formula. I am getting an error and not f...
updated due to spelling error in the formula
Sorry, I didn't explain to well
Click the fx button next to the formula bar
then just copy in
= Table.AddColumn(#"Renamed Columns2", "Merged", each Text.Combine({Text.From([project_id], "en-GB"), ", ", Text.From([cost_code_id], "en-GB"), ", ", Text.From([#"line_item_type_id"], "en-GB")}), type text)
hit enter
I really appreciate your help here. I dont know if im working off a different version or if its because im a novice but I can not find an fx button anywhere in query editor.
aah ok,
Click View, then check Formula Bar