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

Create new column using Dax to pull data from 2 table to make the new column

Hi

I have 2 tables. in which I need to create a new Column where its pulling data from both tables. Table 1 is the main table that has the key information that is related to Table 2 Primary Item Nmber. Table 1 has some part numbers that are longer in nature the Dax formula needs to look at table 2 Engineering item number to find the same part number to makethe new column 

 

Table 1

bu965_0-1639771088017.png 

Table 2 

bu965_1-1639771285916.png

Table 1 with new column

bu965_2-1639771668915.png

 

 

1 ACCEPTED SOLUTION

Hi @Anonymous 

 

This is the correct code:

column =
VAR AA =
    LEN( [CPARTN] )
VAR BB =
    LOOKUPVALUE(
        'table 2'[Primary Item Number],
        'table 2'[Engineering item number], table[CPARTN]
    )
RETURN
    IF( AA = 7, [CPARTN], BB )

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: 
www.linkedin.com/in/vahid-dm/

 

 

View solution in original post

5 REPLIES 5
VahidDM
Super User
Super User

Hi @Anonymous 

 

try this to add a new column:

 

column=

var AA= len([CPARTN])

Var BB= lookupvalue(table 2[Primary Item Number], table 2[Engineering item number], table[CPARTN])

 

return

if(AA=7,AA,BB)

 

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: 
www.linkedin.com/in/vahid-dm/

 

 

Anonymous
Not applicable

The Dax expression works fine that you gave but forgot to add that I have duplicate  values in the table so i get the error - A table of multiple values was supplied where a single value was expected . I appreciate any help. Thanks

Anonymous
Not applicable

Hi VahidDM

I was able to create the column with your information and it was what I am looking for but wanted to see where the column value is 7 that it would be equal to CPARTN number. 

 

bu965_0-1639780107461.png

 

Hi @Anonymous 

 

This is the correct code:

column =
VAR AA =
    LEN( [CPARTN] )
VAR BB =
    LOOKUPVALUE(
        'table 2'[Primary Item Number],
        'table 2'[Engineering item number], table[CPARTN]
    )
RETURN
    IF( AA = 7, [CPARTN], BB )

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: 
www.linkedin.com/in/vahid-dm/

 

 

Anonymous
Not applicable

Hi VahidDM

The Dax expression works fine that you gave but forgot to add that I have duplicate  values in the table so i get the error - A table of multiple values was supplied where a single value was expected. I appreciate any help. Thanks

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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