Forum Discussion

PowerBIRyan's avatar
PowerBIRyan
Regular Visitor
6 years ago

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...
Need Help
PowerBIRyan's avatar
PowerBIRyan
Regular Visitor
6 years ago

The first formula is not being accepted by BI. Not sure why but I can't click OK after entering it. On the second one, should I be using something else instead of Renamed Columns? BI is saying the name is not recognized.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

  • PowerBIRyan's avatar
    PowerBIRyan
    Regular Visitor
    6 years ago

    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.  

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      aah ok, 

       

      Click View, then check Formula Bar