Forum Discussion
How to link when two columns dont match
Hi All, I have Customers in table 1 and table 2 and they are linked. Some of customers are not in table 2 so the ones which dont match, I am getting filter as blank. However I want Blank to be shown...
Alex87
Solution Sage
Solution SageHello,
you have a referential integrity problem in your model. That generated the blank row. You need to create a dimension that takes both the vales from table 1 and table 2 in Power Query.
If my reply is not clear enough, please provide a sample data for table 1, table 2 and the relationship between the two.
Hi, Please see the relationship and data