Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
shoof
Regular Visitor

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].  I am trying to reference a column in a table variable.  How is this done?  Thanks in advance.  

 

=

VAR CurrentYear = Custom_Mix_Tbl_Annual_Return[Year]

VAR InvestmentMixTable = FILTER ('Custom_Mix_Tbl Unpivoted',[Investment Mix] = Custom_Mix_Tbl_Annual_Return[Name])

 

RETURN

Iferror(SUMX (

InvestmentMixTable,

LOOKUPVALUE (

Appended_Historical_Annual_Returns[Annual Return],

Appended_Historical_Annual_Returns[Ticker],

InvestmentMixTable[Ticker],

Appended_Historical_Annual_Returns[Year],

CurrentYear

)

* [Value]

),Blank())

2 REPLIES 2
Greg_Deckler
Super User
Super User

@shoof MAXX( FILTER( ... ), [Column] )


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.