The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
78 | |
77 | |
43 | |
38 |
User | Count |
---|---|
150 | |
116 | |
66 | |
64 | |
55 |