Populate table 1 with data from table 2

[gushal]

Hi,

I want to populate data in a new column in Table1 based on data in Table2.

Example:

Table1:

ColumnA:

11111

11111

22222

22222

33333

44444

Table2:

ColumnA:           ColumnB:

11111                 Zone1

22222                 Zone2

33333                 Zone1

44444                 Zone3

So I want to add a new column in Table1 and populate the zones from columnB in table 2. I need to match ColumnA in Table1 with ColumnA in Table2 and fetch the data in ColumnB in Table2 based on matching values.

How do I do that?

Thanks in advance!

[Jihwan_Kim]

Hi, @gushal 

I suggest having a relationship like the one below. Then writing a formula becomes much easier.

Please check the below picture and the sample pbix file's link down below.

New Column CC =

RELATED(Table2[ColumnB])

https://www.dropbox.com/s/asi48qiuj2bgdp8/gushal.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak · Accepted solution]

@gushal , a new column in table 1

maxx(filter(Table2,Table2[ColumnA] = table1[ColumnA]), Table2[ColumnB])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8