Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to import longitude/latitude data for addresses in my data sets. Since my address data fields in both datasets vary in format (E. 100th st VS East 100th Street) I am not able to join these tables unless there is an exact match. I would like to be able to look up these addresses and import longitude/latitude data per line and use them as my joining keys for both tables.
PLEASE HELP
Solved! Go to Solution.
Hi @Anonymous ,
You may use the LOOKUPVALUE function like DAX below.
Column1= LOOKUPVALUE(tableA[goal field], tableA[linked field], tableB[linked field]))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You may use the LOOKUPVALUE function like DAX below.
Column1= LOOKUPVALUE(tableA[goal field], tableA[linked field], tableB[linked field]))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |