Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kennedy311
Advocate I
Advocate I

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

...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??

1 ACCEPTED SOLUTION
Whitewater100
Solution Sage
Solution Sage

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

View solution in original post

2 REPLIES 2
kennedy311
Advocate I
Advocate I

This did the trick, thank you!!

Whitewater100
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.