Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Michael Michniadowicz]

?I  need to add one column to an existing table.
But the values come from the column in a different table.
Add column from table below

Add it to this table

I don’t care about order, I can sort it later. Just need to add this particular column to the table.
I know, it’s only two records, but this is just a test for larger datasets

——————————
Michael Michniadowicz
2102078768
——————————

[Farhan Ahmed]

Do you have any joining condition between your tables?
If yes, try use “MERGE Queries” 

If where is no joining keys between tables then create 1 column in Table with with Value = 1 ,and same column in Table 2 with Value =1
Then use merge and join both tables, it will create Cross Join between your tables.

——————————
Farhan Ahmed
Senior Business Intelligence Consultant
karachi
3452523688
——————————
——————————————-

[Peter Sladen]

Assuming the tables are appropriately related in your model then you can create a calculated column in your second table and say something like
NewColumn = RELATED(GoalValue)
The “appropriately related” bit is important. You might need to aggregate if second table is at higher grain, or you might get duplicate values if at lower grain. 
I find this a quicker and easier way of doing this kind of thing if it’s all I need from the other table, and I don’t want to simplify the model for any other reasons, otherwise Farhan’s suggestion of merging etc is probably the way forward.

——————————
Peter Sladen
Data Developer
7220502304
——————————
——————————————-