Forum Discussion
Creating a relationship between two tables where one includes NULL values
Hello, I am trying to join one table which has a set of keys + transactions with a member table containing a member key. Our Member Table currently contains two keys, let's call them Key 1 a...
Anonymous , Power bi will not take null on 1 side of the table. You can use replace the value in power bi and replace it with a value like N/A
Is there a particular reason for Power BI not managing to handle NULL values?
Also, wouldn't a value like "N/A" also cause duplicates, creating a relationship that won't work?