Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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())
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
80 | |
69 | |
60 |