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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Try changing the data type in the Query Editor first?

 

 

PowerBIRyan's avatar
PowerBIRyan
Regular Visitor
6 years ago

Thanks Anonymous , I checked and everything im referencing in the formula is Whole Number. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Can you see if the following works 

    = Table.AddColumn(#"Added Custom", "Merged", each Text.Combine({[project)id], ", ", [cost_code_id] ", ", [line_item_type_id]}), type text)

     

    or the following

     

    = Table.AddColumn(#"Renamed Columns1", "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)

    • 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