Fill New column based on value in excel sheet

[Anonymous]

Hi guys, newbie here.

I have a table in my PowerBi where each employee ID is repeated as many times as I have days in my project. 

I was told I need to add a column to this table and given an excel sheet. ( Need to incorporate the second columns of this excel sheet to my powerBI matching the IDs with the Control Budget Weeks number associated with it)

Each unique ID is associated with the number of this second excel column.

Is there a formula to automate that? When the ID is repeated in my PowrBi, the same number of control budget weeks need to go there in that new column.

Sorry for the long text, tried to be as thorough as possible.

and thanks in advance!

Ouss

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may use Merge Queries (Table.NestedJoin) in Query Editor or LOOKUPVALUE Function in DAX.

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may use Merge Queries (Table.NestedJoin) in Query Editor or LOOKUPVALUE Function in DAX.

[Anonymous]

Thanks for replying!

Is there a difference between both? I know vlookup in excel. Is is similar? 

[mussaenda · Accepted solution]

Hi @Anonymous ,

The difference between the two:

Merge Queries are done in POWER QUERY.

and you are joining the tables.

LookupValue is done in DAX.

and you are not literally joining the tables.

You can also try both to see the difference and see which one you are comfortable to use.