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
Solved! Go to Solution.
@Anonymous ,
resulr column name = coalesce([New column], [Column])
Assuming [New column] is blank()
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.
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.
Hi Team,
How to impliment the same logic in power query
Thanks!!
Nagaraju
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!
@Anonymous ,
resulr column name = coalesce([New column], [Column])
Assuming [New column] is blank()
@Anonymous
please try to create a column.
Column = if(ISBLANK('Table'[NEWNAME]),'Table'[NAME],'Table'[NAME])
Proud to be a Super User!
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
209 | |
48 | |
45 | |
44 | |
39 |
User | Count |
---|---|
262 | |
211 | |
103 | |
78 | |
67 |