Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Error trying to create a new column

I have created a new table in power query and have connected it to the orginal data and am now trying to create a new column to add to my data source and when I enter the formula to create the new column I am getting the following error:  

The column 'Title Table[Original Title]' either doesn't exist or doesn't have a relationship to any table available in the current context.

 

I am confused why its not working, any thoughts what step I may have missed?

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    Anonymous , In a new column, you can just use the column name. Table name[column name] is a list in the power query

    Also within table steps; the table name is the last step table name, not the final table name

     

    so [column name] = "ABC" will work

     

    but

    TableName[column name] ="ABC";   can error

     

    Also within table steps; the table name is the last step table name, not the final table name

     

    Prefer to click on the column name suggestion