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 ...
HotChilli
Community Champion
Community ChampionI think you will have to investigate the data quality of the columns as it looks like there's a difference between tables. You can do this in power Query, using column quality, distribution, profile from the View menu.
Are the ID columns text? If so they might need a Trim to remove spaces etc.