cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MAHAD
Helper III
Helper III

DAX Lookup help

Dear Experts

 

BasicMat = LOOKUPVALUE('Material Master'[basic_material],'Material Master'[mat_id], 'New_Mat'[Model_Number]," ")

 

I have a Material Master Table and New_Mat Table. I need to lookup and retrive the Basic_Material from Material Master table. If no match is available then instead of blank the BasicMat field should keep the value of New_Mat.

 

Can anyone please help me to complete the above code.

 

Thanks

Mahad

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

It is for creating a new column.

One thing to note is that 'Material Master'[basic_material] and New_Mat[Model_Number] both column's data type has to be the same.

 

Picture1.png

 

BasicMat CC =
LOOKUPVALUE (
    'Material Master'[basic_material],
    'Material Master'[mat_id], New_Mat[Model_Number],
    New_Mat[Model_Number]
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi,

Please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

It is for creating a new column.

One thing to note is that 'Material Master'[basic_material] and New_Mat[Model_Number] both column's data type has to be the same.

 

Picture1.png

 

BasicMat CC =
LOOKUPVALUE (
    'Material Master'[basic_material],
    'Material Master'[mat_id], New_Mat[Model_Number],
    New_Mat[Model_Number]
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.