Need Help

[Nagraju]

Hi All

I have a two text columns in the table, but i need to combine the two text columns make it as one.

Below are the examples

in the below table i have Name column and New Name Column. I need to combine the two columns and the condition is where ever New Name having the text it needs to be come othere wise Name has to come ,like  Result Column name in Below Image.

 Please find the Image for your refrence

Thanks!!

Nagaraju

[v-kelly-msft · Accepted solution]

Hi @Nagraju ，

Create  a measure as below:

Result column name = 
IF(SEARCH(MAX('Table'[Name]),MAX('Table'[New Name]),1,0)=0,MAX('Table'[Name]),MAX('Table'[New Name]))

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Nagraju ,

resulr column name =  coalesce([New column], [Column])

Assuming [New column]  is blank()

[ryan_mayu]

@Nagraju 

please try to create a column.

Column = if(ISBLANK('Table'[NEWNAME]),'Table'[NAME],'Table'[NAME])