Lookup & Reference • Excel to Power BI Transition

Convert Excel INDEX MATCH to Power BI DAX

Replaces classic Excel INDEX/MATCH formula pairs with direct Power BI LOOKUPVALUE statements.

Target DAX Table:

' '

Instant Samples:

SAP WebI Formula ([Object] syntax)

0 characters Press any key to translate in real-time

Power BI DAX Measure

-- Output will appear here automatically

Syntax Validated Ready for Power BI Desktop & Fabric

Evaluating formula...

Excel Spreadsheet Formula Excel

Standard Syntax: =INDEX(return_range, MATCH(lookup_val, lookup_range, 0))

Sample Excel Formula: =INDEX(PriceList[Price], MATCH(A2, PriceList[SKU], 0))

Power BI DAX Measure DAX

Equivalent DAX Code:

ConvertedMeasure = 
LOOKUPVALUE(
    'Sales'[PriceListPrice],
    'Sales'[PriceListSKU],
    A2
)

Architectural Insight:

DAX LOOKUPVALUE raises an error if multiple rows match the lookup criteria. Ensure lookup keys are unique or use MAX/FIRSTNONBLANK iterators.