Forum Discussion
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 table, and then create a column for "ship date" on my Orders table. (no direct relation ship but both are connected to a date table.
Right now, a column is being created (ship date month), but it seems to be grabbing the "due date" from my Orders table.
If the ship date for a particular order is in the future and has not happened yet, I would like the ship date column to return a ZERO.
(I beleive the same thing is happning with my formula for est close month). The Order Date and Due Date columns already exist on my orders table.
How can I bring in, and put in a column, the "est close dates" from my Shipments table?
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
1 Reply
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