- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Delete Line feeds in a column's data
Dear friends, how are you?
My question is this: I want to append two tables that have the same structures, but one column, specifically the Metric column, has an annoying "character" that apparently are line feeds that I don't know how to modify.
For example: I have the metric column of the Bolivia table and I see the following:
Then the Chile column:
How could I homologate them so that they have the same detail in such a way that when it comes to making the FILTERS with DAX, I don't have that inconvenience that I have a Value (List USD) or Units for Chile and another for Bolivia?
Thank you very much in advance.
Best regards!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Here is some DAX code to do it in a calculated column or you could do something similar in PowerQuery
ColumnA = TRIM( SUBSTITUTE( RawColumn, UNICHAR(10), "" ) )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Excellent! Your answer helped me a lot
Here's how I adapted your formula for my case:
Best regards!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Excellent! Your answer helped me a lot
Here's how I adapted your formula for my case:
Best regards!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Great!!! please mark my answer as a solution 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Here is some DAX code to do it in a calculated column or you could do something similar in PowerQuery
ColumnA = TRIM( SUBSTITUTE( RawColumn, UNICHAR(10), "" ) )

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-30-2024 05:50 AM | |||
05-31-2024 11:51 AM | |||
07-30-2024 12:17 PM | |||
06-04-2024 09:55 AM | |||
12-20-2023 07:22 AM |
User | Count |
---|---|
137 | |
107 | |
84 | |
60 | |
46 |