cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jimpatel
Helper III
Helper III

Formula to retrieve different column result if condition met

Hi,

I have 2 tables and i am having really hard time in linking it.

Two tables have several partnumbers (repeated as well) but not identical. Is there any formula to find if Table 2 partnumber match with Table 1 partnumber if yes then i wanted to retrive "Column D" data from Table 1 please.

Thanks

2 REPLIES 2
jimpatel
Helper III
Helper III

Thanks for your reply. When i use below formula, i am getting an error as table of multiple values was supplied.

 

When i try to retrive "Formula column"  i am getting this error, any idea please?

 

Column 3 = LOOKUPVALUE('Level'[Number],'Level'[Com],'Order'[Material])
jcalheir
Solution Supplier
Solution Supplier

Hi

 

You are looking for LOOKUPVALUE. Check the documentation bellow and the attached video.

https://docs.microsoft.com/pt-pt/dax/lookupvalue-function-dax

https://www.youtube.com/watch?v=jUaEdwN9J1I

 

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.