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,
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.
@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
@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
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
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |