Full Outer Join Handling Null Values in common fields

Hii ArvindJha 

Load the Data. Go to Transform Data.

1)

2)

Output:

Please Try this.

I hope this will help you.

Load both tables into Power BI and open the Power Query Editor.
Perform a full outer join using "Merge Queries" on your key column (Column A).
Expand the merged column to include all relevant columns (B, C, D, E).
Add a custom column using an if statement to consolidate values. For example

if [D] <> null then [D] else [E]

Remove the original D and E columns as needed.
Click “Close & Apply” to load the transformed data.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn