Merging Columns in Power BI
In the lecture we had various NULL values in the "MiddleName" column. Now if we want "FirstName + MiddleName + LastName" in a proper format then how to achieve that?
The final PersonName column shouldn't have NULL as the middle name for people who don't have a middle name.
Let me know if you face issues understanding the context of my question.
Find the link of the lecture here.
Thanks
2 answers ( 0 marked as helpful)
Hi Archisman,
did you try using the Merge Columns function with space delimiter?
But even if I try the Merge Columns with space as a delimiter, won't it take the NULL as the MiddleName and display it in the final output. For example, the name might be like "Dimitar NULL Shutev" ?