Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 looku...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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.

     

     

    BasicMat CC =
LOOKUPVALUE (
    'Material Master'[basic_material],
    'Material Master'[mat_id], New_Mat[Model_Number],
    New_Mat[Model_Number]
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

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.

 

 

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