Forum Discussion
IF statement Coordinated between 2 Table
Anonymous 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.
Anonymous 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.
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,
Anonymous no need to apologize, that's what learning and this forum is for. Glad it's working!