Adding a column with related values from other table

[vyny17]

Hi there! 

I have been facing a problem wich I don't have idea how to solve it, here it is

I want add the column (Effort_in_decimal) from this table to another:

  here is the column i want to add in another table that also have the "nome" and "data" column in it

The key thing is that i want kind of broadcast this column (with DAX language) according to each relative value from "nome" and "data"

  that's the table i want to add the column, keeping the relation from "nome" and "data" from the first table, got it?

If someone there could help me on that one I'd be really thankful

[v-luwang-msft · Accepted solution]

HI @vyny17 ,

You could create new column on the table you want to add column:

Column = LOOKUPVALUE(TableA[value],TableA[date],TableB[date],TableA[name],TableB[name])

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[vyny17]

That's exactly what I wanted!

Thank you very very much!

[amitchandak]

@vyny17 , Based on what I got, a new column in table 2

Maxx(filter(Table1, Table1[Noma] = table2[Noma] && Table1[data] = Table2[Data]) , Tabel1[effort_in_decimal])

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