Appending Queries after new columns are added

[jcastr02]

I've appended three queries together - 30 day surveys, 60 day surveys, and 90 day surveys.  I've now added the same name column "Time To Complete" to each of those queries, but I don't see it on the query I had built previously where I had appended these three.  How can I now show this new column?

[v-yingjl · Accepted solution]

Hi @jcastr02 ,

How did you add [Time To Complete] column to three queries? Enter data manually or create calculated column?

If you enter data column manually, it will show in the appended table after appending these three tables into a new appened table.

If you created calculated column, it will not show in power query, you can try to use selectcolumns() or union() function to create a calculated table.

You can refer this similar issue:  Calculated Columns disappeared after Append Queries 

Best Regards,
Yingjie Li

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

[amitchandak]

@jcastr02 , you have to add a calculated column before merge in these three tables.

[jcastr02]

@amitchandak I already had appended these three queries into a new query and I have many visuals tied to it.  I would like to avoid having to undo all of it, is the only option to append again as a new query to have the newly added columns show up ?

[Syndicate_Admin]

I have the same problem, I don't know how to fix it.