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.])
az38's avatar
az38
Community Champion
6 years ago

Hi Kfausch 

try a column

Column =
LOOKUPVALUE('Table'[Lot No.], 'Table'[Entry Type], "Output", 'Table'[Document No.], [Document No.])

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

Kfausch's avatar
Kfausch
Helper II
6 years ago

I am getting this error "A table of multiple values was supplied where a single value was expected." I think its because the table has multiple production Document No.'s.

 

Thanks for you input!