Forum Discussion

RP_OFaustino's avatar
RP_OFaustino
Helper I
5 years ago

Case Sensitive Lookup Value

Hi Everyone,

 

I am trying to do a lookupvalue in Power Bi with Salesforce's 15 Digit Contact ID Field but to no success (obviously because of duplicate IDs).

 

Here are my questions:

 

1. Is there a way to have a case sensitive lookupvalue?

2. Can FIND FUNCTION be used to look up for values in another table?

3. Are there other ways to do a case sensitive vlookup in Power Bi?

 

I cannot use relationships because the data given to me by Sales are all 15 Digit Contact IDs.

 

Any suggestion is greatly appreciated.

 

Thank you.

 

 

 

Need Help
Tips and Tricks

3 Replies

    • RP_OFaustino's avatar
      RP_OFaustino
      Helper I
      5 years ago

      Hi ryan_mayu , these sir are my tables. the 1st one is from sales. and the 2nd one is from Salesforce.

       

      The goal is to find the form details of the contacts of the sales team list from Salesforce. Thank you.

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        5 years ago

        RP_OFaustino 

        so, there are duplicated values in both table? Then what's the logic to get data? earlieast? latest? or something else.

        It's better to provide some non-sensitive data and expected output.