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

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" ?

Follow this topic

Archisman Das

Last answered:

01 Nov 2021

Posted on:

28 Oct 2021

Merging Columns in Power BI

in Power BI / Introduction to Power BI

2 answers ( 0 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

31 Oct 2021

Archisman Das

Posted on:

01 Nov 2021

Merging Columns in Power BI

Submit an answer

related questions