There are 2 tables in this particular case and they have an inactive 1-m relationship. (because the data model are more complicated, cannot make the relationship active)
The fact table looks like this:
The dimention table(Business Unit) is like this:
I want to add BU_name into the fact table accordingly, and I use:
but it returns the wrong value.
Can someone help with this problem? Thank you so much!!