Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Having trouble with Lookup

In trying to use the Lookup funtion, I believe I am doing something incorrectly.     My expected outcome is that from within my Orders table, I want to "lookup" the ship date from my Shipments tabl...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

    I think you should move the date based on order no or something like that. Another way to get a column from one table 2 to table 1

    New Column = maxx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])

     

    Refer to the order dimension in this file. it has an example

    https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,

I think you should move the date based on order no or something like that. Another way to get a column from one table 2 to table 1

New Column = maxx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])

 

Refer to the order dimension in this file. it has an example

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0