topic Write a value to table based on column matching in DAX Commands and Tips

Write a value to table based on column matching

Anonymous — Thu, 12 May 2022 17:30:54 GMT

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

...and a bunch of other columns not relevant here

I am trying to pull the Unique ID and PY Revenue values from Table1 into Table2, by matching on Client Name. I can't quite figure out how to do this without throwing errors. And yes...I have to match on Client Name in this case. Help??

Re: Write a value to table based on column matching

Whitewater100 — Thu, 12 May 2022 18:41:39 GMT

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

Re: Write a value to table based on column matching

Anonymous — Thu, 12 May 2022 20:56:31 GMT

This did the trick, thank you!!