Forum Discussion
RP_OFaustino
5 years agoHelper I
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 t...
ryan_mayu
5 years agoSuper User
Could you pls provide the sample data and expected output?
RP_OFaustino
5 years agoHelper I
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_mayu5 years agoSuper User
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.