Forum Discussion
Solved
One-to-Many Relationship with Null Value
Hello All, I hope you are well! I am looking to create a one-to-many link between two tables (Mastertable and Project_Table) based on a column entitled "Project Code." Mastertable has the...
Hello finnprice
Go to Project_Table in Power Query Editor.
Add a step to filter out rows where Project Code is null:
powerquery
Table.SelectRows(Project_Table, each [Project Code] <> null)
or
via UI
Click the dropdown on Project Code column
Uncheck (null)
Apply and Close → Now the relationship will create without error
Thanks,
Pankaj Namekar | LinkedIn
pankajnamekar25
Super User
Super UserHello finnprice
Go to Project_Table in Power Query Editor.
Add a step to filter out rows where Project Code is null:
powerquery
Table.SelectRows(Project_Table, each [Project Code] <> null)
or
via UI
Click the dropdown on Project Code column
Uncheck (null)
Apply and Close → Now the relationship will create without error
Thanks,
Pankaj Namekar | LinkedIn