IF statement Coordinated between 2 Table

[iyogj]

Hi Guys,

I don't know if its possible but i want to Create an IF statement but coordinated with 2 Table.

Image below for clarity.

I have 6 Tables All of them have the Same first name but different Role/Labour Category.

Employee List table have the Labour category which i want to Put into the Level1-5 Role column.

as far my Program line as below which is not working. 

if Employeelist[First name] = Level1[First Name] then Employeelist[Labour Category] = Level1[Role] else Level1[Role] = null

Hoping you could help me again.

thank you.

Cheers,

[AllisonKennedy · Accepted solution]

@iyogj  Why do you need 6 tables? can this all be in one table?

I would suggest you start with the Employee table, then from the Home tab > Merge Queries. Select the Level 1 table, pick the First Name columns in both tables, click Ok.

You'll now have a new column, click the two arrows next to the column heading for this new column and select all the columns you want included from the Level1 table. 

[iyogj]

Hi @AllisonKennedy ,

Thank you for your response.

The Employeelist Table is manually added by different people and the Levels are automatically added from HR software. that's why they are in the different table.

i tried your solution it works but vice versa but the idea is the same. Really thank you. apologies if the solution is so simple enough i am very new to PowerBI. 

Cheers,

[AllisonKennedy]

@iyogj  no need to apologize, that's what learning and this forum is for. Glad it's working!