Forum Discussion
lookupvalue sometimes works
Hello all, i have 2 face tables that are not related to one another but are Via customer Dim table: I need to create a calc colum in Fact Table 2 that looks up a column from Fact Table ...
v-angzheng-msft
Community Support
Community SupportHi, Anonymous
As HotChilli mentioned above, hidden spaces and other invisible characters often affect the lookup result. An easy way is to use the Len function to check whether the string lengths are the same.
Remove the hidden characters and often you will get the correct result.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.