;%20}%20%3c/style%3e%3clinearGradient%20id='linear-gradient'%20x1='2.99'%20y1='29.35'%20x2='127.75'%20y2='101.39'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20offset='0'%20stop-color='%23f2b347'%20/%3e%3cstop%20offset='.5'%20stop-color='%23ca5a8b'%20/%3e%3cstop%20offset='1'%20stop-color='%236654f5'%20/%3e%3c/linearGradient%3e%3c/defs%3e%3cg%20id='Layer_1-2'%20data-name='Layer%201'%3e%3cpath%20class='cls-1'%20d='M83.56,0H47.18C21.12,0,0,21.12,0,47.18v36.38c0,26.06,21.12,47.18,47.18,47.18h36.38c26.06,0,47.18-21.12,47.18-47.18V47.18C130.74,21.12,109.62,0,83.56,0ZM20.62,48.64c2.84-2.84,6.59-4.23,10.32-4.17,3.82,.07,7.55-1.1,10.25-3.8l.56-.56c2.7-2.7,3.86-6.43,3.8-10.25-.07-3.73,1.32-7.47,4.17-10.32,6.18-6.18,16.66-5.48,21.88,2.11,3.18,4.62,3.27,10.96,.19,15.64-3.02,4.6-7.92,6.78-12.72,6.54-3.51-.17-6.95,.99-9.43,3.48l-1.24,1.24c-2.48,2.48-3.65,5.92-3.48,9.43,.24,4.8-1.94,9.7-6.54,12.72-4.68,3.08-11.03,2.99-15.64-.19-7.6-5.23-8.29-15.7-2.11-21.88Zm33.7,34.25c-2.7,2.7-3.86,6.43-3.8,10.25,.07,3.73-1.32,7.47-4.17,10.32-6.18,6.18-16.66,5.48-21.88-2.11-3.18-4.62-3.27-10.96-.19-15.64,3.02-4.6,7.92-6.78,12.72-6.54,3.51,.17,6.94-.99,9.43-3.48l1.24-1.24c2.48-2.48,3.65-5.92,3.48-9.43-.24-4.8,1.94-9.7,6.54-12.72,4.68-3.08,11.03-2.99,15.64,.19,7.6,5.23,8.3,15.7,2.11,21.88-2.84,2.84-6.59,4.23-10.32,4.17-3.82-.07-7.55,1.1-10.25,3.8l-.56,.56Zm55.8-2.93c-2.96,2.96-6.91,4.35-10.79,4.15-3.51-.17-6.96,.99-9.44,3.48l-1.23,1.23c-2.49,2.49-3.65,5.93-3.48,9.44,.19,3.88-1.19,7.82-4.15,10.79-6.18,6.18-16.66,5.48-21.88-2.11-3.18-4.62-3.27-10.96-.19-15.64,3.02-4.6,7.92-6.78,12.72-6.54,3.51,.17,6.95-.99,9.43-3.48l1.24-1.24c2.48-2.48,3.65-5.92,3.48-9.43-.24-4.8,1.94-9.69,6.54-12.72,4.68-3.08,11.03-2.99,15.64,.19,7.6,5.23,8.3,15.7,2.11,21.88Z'%20/%3e%3c/g%3e%3c/svg%3e)
- discover expand_moreMenu chevron_rightDiscover
skills
Choose the data skills that you'd like to master.
Start Learning chevron_rightShow skills
expand_moretools
Access the world's most advanced selection of data tools.
Access Tools chevron_rightShow tools
expand_moreCreate Your Personal Learning Plan
Learn the practical skills you need to solve real-world data challenges.
Get Started chevron_right
- platform expand_moreMenu chevron_right
Learning Center
expand_moreProject Center
expand_moreProject Center
Community
expand_more - individuals
- business expand_more
- pricing
DAX Function Guide
LOOKUPVALUE
Sam McKay
CEO & Founder
How does the LOOKUPVALUE work?
Returns the result_columnName value for the row that meets all of the search_columnnName and search_value criteria.
LOOKUPVALUE Formula Syntax
LOOKUPVALUE ( <Result_ColumnName>, <Search_ColumnName>, <Search_Value> [, <Search_ColumnName>, <Search_Value> [, … ] ] [, <Alternate_Result>] )
How do you use the LOOKUPVALUE?
The value of result_column at the row in which all search_column and search_value pairs match.
Related Blog Posts
Loading
Considerations when using the LOOKUPVALUE?
If there is no match that satisfies all the search values, then a BLANK is returned. In other words, if only some of the parameters fit, the function will not return a lookup value.
If the search values match multiple rows, and Result Column values are identical in all cases, then that value is returned. If Result Column returns different values however, an error is returned.
The Search_ColumnName can be any column referenced by Result_ColumnName of the expanded table.
Related Video Tutorials
Loading
Formula examples using the LOOKUPVALUE
LOOKUPVALUE (
ExchangeRates[Rate],
ExchangeRates[Date], DATE ( 2018, 4, 15 ),
ExchangeRates[Currency], “EUR”
)
LOOKUPVALUE (
ExchangeRates[AverageRate],
ExchangeRates[Date], DATE ( 2018, 4, 15 ),
Currency[Currency Code], “EUR”
)
Related Courses
Loading