Forum Discussion
VLOOKUP Equivalent Formula Working except for one row
Hi all, I am using the following formula: CALCULATE(FIRSTNONBLANK('Factory Output'[Production Line],1),FILTER('Factory Output','Factory Output'[Lookup]='SKU - Monthly S82 Actual Cost of Produc...
Just an FYI, the value that isn't picking up the formula correctly happens to be the last line in the dataset as well