Need Help

[Anonymous]

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

[amitchandak · Accepted solution]

@Anonymous ,

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

Assuming [New column]  is blank()

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

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!

[Syndicate_Admin]

Hi Team,

How to impliment the same logic in power query

Thanks!!

Nagaraju

[Syndicate_Admin]

There @Nagraju ,

Create a new thread in power query forum,we will help to check it.

Best Regards,
Kelly

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

[amitchandak · Accepted solution]

@Anonymous ,

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

Assuming [New column]  is blank()

[ryan_mayu]

@Anonymous 

please try to create a column.

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