Forum Discussion
Solved
Merge Issue | Replace NULL
Hello Power BI Community, I'm trying to merge two table in Power BI queries, and I used full-outer join. As you can from the result screenshot below, It didn't quite merge the two, so I tried to...
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.
I would suggest if the record set model is a reasonable record count and not gigantor: Append (not merge) 1 column to the other for a single long column. Then create a column using DISTINCT or VALUEs so to eliminate all duplicates.