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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

New column with values from table via another table

First post here 🙂 Let's see if I can make any sense.

 

My main table, Table1, needs a new column with numbers from column A in Table3. Table1 has a column with IDs that match a column in Table2. Table2 has another column with names that match column B in Table3. I need to use LOOKUP and perhaps RELATED to get the numbers from column A in Table3 into a new column in Table1.

 

So far I've only figured out how top to get numbers from "one table away".

 

Can you help me out? Thanks in advance:)

1 REPLY 1
Anonymous
Not applicable

I’m gonna answer my own question and say that I could make a new column in Table2 with the numbers I need from Table3. Then I can use lookup to make the column I need in Table1 with the new info I now have in Table2. Right?!

 

But there must be a way to do this in one step, or..?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.