cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnnyK
Advocate I
Advocate I

Missing a common column in an Apended as New table

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.  

123

456

1 ACCEPTED SOLUTION
Tahreem24
Super User II
Super User II

@JohnnyK  - Also attaching screen shot for your reference.

Capture.PNG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report

View solution in original post

5 REPLIES 5
JohnnyK
Advocate I
Advocate I

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

TarunSharma
Resolver III
Resolver III

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
Super User II
Super User II

@JohnnyK  - Also attaching screen shot for your reference.

Capture.PNG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report

View solution in original post

Tahreem24
Super User II
Super User II

@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...
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report
amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.