Forum Discussion
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 doing a crossover comparing "NUMBER" in "task_sla" (in the field "TASK") and comparing "TASK" in "sn_sm_finance_request" (in the field "NUMBER" and then remove some duplicated values to match both Excel files.
I'm starting to work with Power BI and I want to know if there's a way to apply this (with formulas, don't know, I'm a newbie) to automate this process I do in Excel into Power BI.
Is there's a way. How formulas, which Power BI processes should I look? Maybe como bibl
Hope you can support
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.
1 Reply
v-jianboli-msftCommunity Support
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.