Forum Discussion

cesarfg1991's avatar
cesarfg1991
New Member
3 years ago
Solved

How to do a vlookup between two excel and remove duplicates in Power BI

I have 2 excel files ("task_sla", "sn_sm_finance_request") with matching columns (same values) in the column "NUMBER" for "sn_sm_finance_request" and "TASK" in "task_sla".   In Excel I used VLOOKUP...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi cesarfg1991

     

    You can use the DAX function LOOKUPVALUE(). 

    It returns the value for the row that meets all criteria specified by one or more search conditions.

     

    Syntax:

    LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value> [, <search2_columnName>, <search2_value>]… [, <alternateResult>] )

     

    For more details, please refer to: LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi cesarfg1991

 

You can use the DAX function LOOKUPVALUE(). 

It returns the value for the row that meets all criteria specified by one or more search conditions.

 

Syntax:

LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value> [, <search2_columnName>, <search2_value>]… [, <alternateResult>] )

 

For more details, please refer to: LOOKUPVALUE function (DAX) - DAX | Microsoft Learn

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.