cancel
Showing results for
Did you mean:
Highlighted

## Add Attributs form another table

Hi dear community

Following problem to solve:

I habe two tables (only an overview of data):

Table 1 contains information for which period an employee is assigned to which region / location / group (see picture)

Table 2 contains information about which shift an employee is working on a specific date

What to do? - In table 2, the information should be attached in which region / place / group the employees work.

I am very grateful for your support.

Cheers
qwertzuiop

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV

## Re: Add Attributs form another table

@qwertzuiop , New Columns like this in table 2

Area = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Area])

Same way repeat other two

Location = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Location])
Group = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Group])

Proud to be a Super User!

5 REPLIES 5
Highlighted
Super User IV

## Re: Add Attributs form another table

@qwertzuiop , I think a better idea to merge in power Bi. Select Table 2, merge Table1 and keep the required columns

Proud to be a Super User!

Highlighted
Frequent Visitor

## Re: Add Attributs form another table

Hi @qwertzuiop

You can choose one of  2 solution.

1) Create a relationship with Table1(ID)-->Table2(ID) and create columns with Related() function . For example: create column in Table2 as Area=Related(Table1[Area]) and other columns

2)Use LOOKUPVALUE() Function without relations. for example: Create Column in Table2 as Area=LOOKUPVALUE(Table1[Area],Table1[ID],Table2[ID])

Highlighted

## Re: Add Attributs form another table

Thank you very much for your contribution, but I think it's not thas quick solved.

Why? Because the ID can/will occur several times in both tables, since the employee in table 1 may change the area every month and in table 2 he/she carry out a new shift every day.

So I have to check, in which time period (from-to) the date of the shift fits and matches the id.

Then it should be possible for me to tell you later, which employee performs a shift in which region based on the date.

Got it?

Thaaanks a lot.

Cheers

qwertzuiop

Highlighted
Super User IV

## Re: Add Attributs form another table

@qwertzuiop , New Columns like this in table 2

Area = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Area])

Same way repeat other two

Location = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Location])
Group = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Group])

Proud to be a Super User!

Highlighted

## Re: Add Attributs form another table

Sorry for my absence.

Thank you very much for your support.
The solution you gave me here works.

Have a nice day - you saved mine 😉

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (857)