Forum Discussion

GeorgW's avatar
GeorgW
Helper II
5 years ago
Solved

Display/insert data from one table into another

Hello, I have two tables; the "Employees" table and the "Additional Information" table. I now want to copy from the "Additional Information" table the values from the fields "Company", "Contract" an...
Need Help
  • GeorgW's avatar
    GeorgW
    5 years ago

    I have solved it now with "CONCATENATE" (the Employee ID, Year and Month) and then with "LOOKUPVALUE". And it works 🙂

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  GeorgW ,

Here are the steps you can follow：

1. Create calculated table.

Table 2 = SUMMARIZE('Table',
'Table'[Employye ID],'Table'[Name],'Table'[birthdate],'Table'[sex],'Table'[Department],'Table'[Location],'Table'[Year],'Table'[Month],
"Company",CALCULATE(MAX('Table (2)'[Company])),
"Contract",CALCULATE(MAX('Table (2)'[Contract])),
"Contract type",CALCULATE(MAX('Table (2)'[Contract type]))
)

2. Result.

You can downloaded PBIX file from here.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.