Forum Discussion

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago

How to Lookup a Value in Another Table

Hello,   I am trying to lookup the country in BSA00RMMC and return the Balance USD.  My Existing table I am creating the Measure in is GL001111. How can I perform this lookup? The below code does ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

The blog post discusses ways of doing the equivalent of VLOOKUP in Power BI. Power BI does not have a VLOOKUP DAX function so you have to do it differently.

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago

I Understand. Yes I mislabled . 

 

Looks like I need to pass this along to a paid consultant.  Reading your article has only confused me and I still cant dfind any Solid resource showing an example.

 

Again, this should be so simple, and it is for excel and SSRS reporting. Power BI doesnt seem to handle this kind f thing very well.

 

The formula I provided worked for the same EXACT type of situation using a date field, but doesnt work on these two tables.

 

Wish Power BI had a Payment option so we could get answers from DAX experts quickly.  Maybee Ill debvelop that website and make tons of money.

 

Thanks again for attempting to help.

 

 

 

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    lcasey

     

    I assume you have multiple 'BSA00-RMMC'[Balance USD] for same 'BSA00-RMMC'[COUNTRY]. And you have country column with distinct values in your existing table. Right?

     

    In this scenario, since you have country column in both tables, you should create the relationship between these two tables. Then you just need to create a measure like "=CALCULATE(SUM('BSA00-RMMC'[Balance USD]))", it will aggregate the 'BSA00-RMMC'[Balance USD] on country level.

     

    If you don't want to create relationship, you have to create a calculated table, summarize the 'BSA00-RMMC' table with 'BSA00-RMMC'[COUNTRY] column and an aggreagated 'BSA00-RMMC'[Balance USD] column. Then you can create a calculated column with LOOKUPVALUE() to get the 'BSA00-RMMC'[Balance USD] into your existing table.

     

    Regards,