Forum Discussion

Kfausch's avatar
Kfausch
Helper II
6 years ago
Solved

Look up value formula

Hello,   Below is an example if the data I am working with. I am in a manufacturing setting, where 1 document has two entry types; output and consumption. The column called "Output Lot No." is what...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try

    new Column =
LOOKUPVALUE('Table'[Lot No.], 'Table'[Entry Type], "Output", 'Table'[Document No.], firstnonbank('Table'[Document No.],true()))
OR
new Column =
minx(filter('Table', 'Table'[Entry Type]= "Output" && 'Table'[Document No.]= earlier('Table'[Document No.])),'Table'[Lot No.])
amitchandak's avatar
amitchandak
Super User
6 years ago

Try

new Column =
LOOKUPVALUE('Table'[Lot No.], 'Table'[Entry Type], "Output", 'Table'[Document No.], firstnonbank('Table'[Document No.],true()))
OR
new Column =
minx(filter('Table', 'Table'[Entry Type]= "Output" && 'Table'[Document No.]= earlier('Table'[Document No.])),'Table'[Lot No.])
Kfausch's avatar
Kfausch
Helper II
6 years ago

Great the second formula worked! Thank you!!

 

test lot = minx(filter('ILE - Production', 'ILE - Production'[Entry_Type]= "Output" && 'ILE - Production'[Document_No]= earlier('ILE - Production'[Document_No])),'ILE - Production'[Lot_No])