- 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
Extract text after/before certain symbol
Hi all,
How can i extract the text from each side of a symbol in DAX?
I have tried to apply the following formula: =LEFT(B2;(FIND("/";B2;1)-1)) , which works in excel.
However, when i use the following formula: =LEFT([GRUPPE];(FIND("/";[GRUPPE];1)-1)) , in powerpivot, referencing the column that i want to look up, it returns the following error:
"The search Text provided to function 'FIND' could not be found in the given text"
What am i doing wrong?
Best regards
Rasmus Röck
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Rasmusrock you have to use the fourth (conditional) parameter of the FIND function - it is used when the text which has to be found is not found - you have data where the "/" is not contained.
Then will your formula work.
Regards.
Pavel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Rasmusrock you have to use the fourth (conditional) parameter of the FIND function - it is used when the text which has to be found is not found - you have data where the "/" is not contained.
Then will your formula work.
Regards.
Pavel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @PavelR,
Thank you very much for your reply.
I think it solved the initial problem, however, i am stilling getting an error. The error i get now is:
"Calculation error in column 'Varegrupper'[]: Cannot convert value 'Outdoor Living/Flower pots' of type Text to type Integer."
For info, 'varegrupper' is the tab i am working in, and 'outdoor living/flower pots' is one of the text strings i am trying to dissolve so i have one column with the 'outdoor living' part and one with the 'flower pots' part.
Hope you can help,
/Rasmus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-13-2023 08:39 AM | |||
03-17-2025 05:37 PM | |||
01-21-2025 09:49 PM | |||
11-21-2024 01:30 PM | |||
10-31-2024 06:01 PM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |