Forum Discussion
Power Query and Power BI different behavior in managing null values in concatenation
Hi everyone, I had the need to create a Primary Key in a "Country" dimension table (concatenating the ZIP_Code and the Country_Name) because I needed to create a relation between this dimension t...
Actually I've done the same steps written here in the "Merge columns to create a new column" section: https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d#:~:text=Select%20two%20or%20more%20columns,Select%20Transform%20%3E%20Merge%20Columns.
And the result was the one of the previous message.
Is there any other way to merge columns?