Help with DAX RELATED function

Thanks v-easonf-msft and amitchandak  for your suggestions

Interestingly I found the problem in the original dataset but now I'm not sure how to fix it for future data imports - the fix was to delete the single space between first name and last name in the timesheet data set and then re add the space. There was no double spaces so it looks like what is coming out of the timesheet system is not an acutal space.  I checked this in Query Editor by extracting before delimitter (with 'space' set as the delimitter) and only the modified entries extract, all the others remain as the full text suggested the delimitter doesn't exist. 

I tried a few other delimitters e.g.  comma,  %20  to see if I could figure it out but I cannot. Is there anyway to see/check what the delimitter actually is or otherwise fix this? (When extracting the length both the 'fixed' and 'not fixed' versions have the same number of characters so *something* is there!) There is 9000 entries in the timesheet data so manual is not going to happen 😂