1 to many relationship with nulls on "many" side

[Anonymous]

Hi, I have created a 1-to-many relationship and am then using the RELATED() function to bring data from the "one" to the "many" side. 

I am creating a relationship with a cost code category (just a code to bucket certain costs). However, the "many" table is missing a cost code category that the "one" table has. Thus, I do not see that cost code when I visualize the "many" table with data from the "one" table.

Is there a way to create a new table that populates with the one and many data? This way, a row will be created with data from the "one" side, even if the "many" side is missing that category?

Thanks for your help, I really appreciate it!

[mwegener]

Hi @Anonymous ,

Can you provide example data or an example model?

[amitchandak · Accepted solution]

@Anonymous , You can check the merge option in the power query

https://radacad.com/append-vs-merge-in-power-bi-and-power-query