Forum Discussion
Helper VRelation many to many with null values
Hello all, I need one advice .
I have one relationship in PowerBI Many 2 Many between fact table and DIM table .
In the fact table the many is caused by null vallues in my SQL, in the dim table it's really many values.
You thinks the results it's ok ? I can delete the null value in my fact table .
Thanks for your tips!
2 Replies
- amitchandak
Super User
Vanessa250919 , If there a null value on dimension (1- side of the table) power will not create 1-M join.
Remove that row in the power query on the dimension side.
Or replace with a value like "n/a" (-1) in power query;in both dimension and fact table
- Vanessa250919
Ok thanks for your answer, but if I understand well your answer the real issue Is it with null values. But, if I replace null by N/A for example, I create a duplicate value... Not one issue for 1 to many ?
