Forum Discussion
How can I reference a column in a DAX variable table in a LOOKUPVALUE function?
So I have this DAX formula below. In the LOOKUPVALUE function I need to lookup the values in the Ticker column in the variable InvestmentMixTable. This syntax doesn't work InvestmentMixTable[Ticker...
shoof MAXX( FILTER( ... ), [Column] )
So are you saying to replace the lookupvalue completely? Or do this...
Maxx(Filter( InvestmentMixTable),[Ticker]))
The Ticker column is Text. Don't know if that matters.