Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 I am trying to do in Power BI. Essentially I am looking for a formula that will look up the lot number used for output and apply it to all lines with the same Document No. but I cannot find anything that works.
Any help would be greatly appreciated!
Kevin Fausch
Solved! Go to Solution.
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.])
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.])
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])
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |