cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

Table 2

Table 1 with new column

1 ACCEPTED SOLUTION
Super User

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.

5 REPLIES 5
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.

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.

Super User

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.

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

Announcements

#### New forum boards available in Real-Time Intelligence.

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors