Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Write a value to table based on column matching

I'm not sure I'm asking the question correctly, but here it goes:   I have two tables. Table1 has these columns:   Client Name Unique ID Previous Year's Revenue   Table2 has:   Client Name ...
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    Besides merging the two tables in Power Query you can try as calculated columns in Table 2.

    Unique ID = LOOKUPVALUE(Table1[Unique ID], Table1[Client Name], Table2[Client Name])

    and then rpeat same pattern for PY revenue.

    PY Rev = LOOKUPVALUE(Table1[Previous Years Revenue], Table1[ClientName], Table2[ClientName])

     

    I hope this solves this for you. Thanks

Anonymous's avatar
Anonymous
Not applicable
4 years ago

This did the trick, thank you!!