Missing a common column in an Apended as New table

[JohnnyK]

Good day

I'm trying to combine 4 tables into 1.

Each of these 4 tables has a manually added column with fix texts.

I used a “Append Queries as New”, but the new table doesn't show the manually added column.

What it is the right way to combine these 4 tables into 1, with the manually added column? Thank you.  

[JohnnyK]

@Anonymous @Tahreem24 @amitchandak thank you for all of your help!

[Anonymous]

Hello @JohnnyK 
You can't see the calculated column in the power query.
You can use UNION functions with SUMMARIZECOLUMNS to select the desired columns.

[Tahreem24 · Accepted solution]

@JohnnyK  - Also attaching screen shot for your reference.

[Tahreem24]

@JohnnyK ,
You can try the UNION function to combine your all four tables.

Combine Table = UNION(Sheet1,Sheet2,Sheet3)

Go to Modelling tab --> Click on New Table --> Then enter above DAX statement --> You are go to go...

[amitchandak]

@JohnnyK , Please add the new column in power query, using custom column. Then you will be able to see. You will not see column created in DAX there.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-add-custom-column