Forum Discussion
Merge Issue | Replace NULL
It wasn't an issue with Cap Letters nor JOIN nor Merge. When I simply Merge again with FULL JOIN, it finally worked. I am also able to create a DimState from the merged table with combination of IF and Table.Distinct()
Issue resolved. Thank you all.
Hi captainlaw,
In Power BI Desktop, there are multiple options available when using Merge Query feature.
To remove the null value, you can use inner join instead.
Reference
https://businessintelligist.com/2015/09/15/power-bi-desktop-merge-query-options/
Regards,
Charlie Liao
It wasn't an issue with Cap Letters nor JOIN nor Merge. When I simply Merge again with FULL JOIN, it finally worked. I am also able to create a DimState from the merged table with combination of IF and Table.Distinct()
Issue resolved. Thank you all.