How to add new column to new table

[Revathi_Kannan]

Hi all,

I have created a "new table" in Power Bi wherein i need to add new column should be copied from another table name "Updated" "Priya's sql data".

Is that possible ? Kindy assist me.

[Icey]

Hi @Revathi_Kannan ,

Why do you want to "copy" a column from another table? And what's the rule when copying the column?

Best Regards,

Icey

[Whitewater100]

Hi:

It would be good to see the column you want to add and an image of your data model and the columns you have in both tables. Because there are different ways to add. 

If I were to guess (if data model is connected)

New Table = ADDCOLUMNS(

                      SUMMARIZE(Table, 
                     Table[@Categorysum..], 
                      Table[SAP_Customer]), 
                   "Updated", What column are you adding? Priya's sql data [column name??]))

Providing more info will help. Currently you do not show the column you want to add, jsut a Table Name?

Thanks..

[Revathi_Kannan]

@Whitewater100 

Thanks a lot for your response.

I am not able to attach the file here. Also i am new to this forum. Is there anyway to connect you so that i will explain my requirement. 

[Whitewater100]

Hello:

I worked this up in with some excel data. Does this work for you?

https://drive.google.com/file/d/1PkD3r4UrjXkJ9IlDSj4ciJspN7H4AGsG/view?usp=sharing