Lookup & Reference • Excel to Power BI Transition

Convert Excel VLOOKUP to Power BI DAX

Translates Excel vertical lookup formulas into Power BI LOOKUPVALUE measures, avoiding costly relationship circularities.

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

Architecture & Context Transformation:

Evaluating formula...

Excel Spreadsheet Formula Excel

Standard Syntax: =VLOOKUP(lookup_value, table_array, col_index, [range_lookup])

Sample Excel Formula: =VLOOKUP(A2, Products!A:D, 4, FALSE)

Power BI DAX Measure DAX

Equivalent DAX Code:

ConvertedMeasure = 
LOOKUPVALUE(
    'Products'[ResultColumn], 
    'Products'[LookupKeyColumn], 
    A2
)

Architectural Insight:

Unlike Excel VLOOKUP which scans from left to right in a fixed grid, DAX LOOKUPVALUE searches any column in the target table regardless of position, returning blank if no match is found.