Forum Discussion
Solved
Need to return first value when LOOKUPVALUE returns multiple values
Hi All I have a table in my Power BI report which contains a Companyname and Symbol. I want to write a DAX measure where I pass in the Companyname and it returns the Symbol. I pass in the Comp...
andrew_k Use MINX( FILTER( ... ), ... ) instead of LOOKUPVALUE.
andrew_k Use MINX( FILTER( ... ), ... ) instead of LOOKUPVALUE.
Excellent. Thanks Greg!
MINX( FILTER(DimCompanies, [Companyname] = [Selected Stock]),[Symbol])