Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |