Forum Discussion
andrew_k
Helper I
Helper INeed 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.
Greg_Deckler
Community Champion
Community Championandrew_k Use MINX( FILTER( ... ), ... ) instead of LOOKUPVALUE.
andrew_kHelper I
Helper IExcellent. Thanks Greg!
MINX( FILTER(DimCompanies, [Companyname] = [Selected Stock]),[Symbol])