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 as Other in cat 2 . How do I get other instead of Blank.
3 Replies
- Alex87
Solution Sage
Hello,
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.
- Alex87
I does not help me seeing your model. Please provide dummy data if you need additional help.
