Case Sensitive Lookup Value

[RP_OFaustino]

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.

[ryan_mayu]

@RP_OFaustino 

Could you pls provide the sample data and expected output?

[RP_OFaustino]

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]

@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.