Forum Discussion
Partial Matches
HI ecs70206,
I don't know to what extend the slight differences in spelling and spacing you have in your model however you can create a ID column in both tables that removes the spacing and gets part of the names (first 3 letters and last 3 letters or something similar) or make everything in CAPS and then use that columns as a basis for your relationship between tables.
Without data it's difficult to give you an example of the changes that can be made to your information.
Regards,
MFelix
hi guys,
further to this i've anonymised the information as much as I can so i'll post some shots hopefully it'll give a better picture of what im trying to do.
I have two tables - table a contains finance information and table b contains journey information. my problem is that when i count the data there are more distinct entries on the journey sheet than there are on the finance sheet. shown in the picture below. the aim is to identify the ones on the journey sheet that dont appear on the finance sheet in order to extract them and send them over to the orgintor. ive been trying to mess around with dax but i dont understand it enough yet to make it work properly - any help is appreciated
I've extracted the route column from each of the master tables as new queries - the intention is to make a route key. they are set up as follows
the small one is the finance routes and the large one 14k rows is the journey sheet