Forum Discussion

Rasmusrock's avatar
Rasmusrock
Helper II
9 years ago
Solved

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...
Need Help
  • PavelR's avatar
    PavelR
    9 years ago

    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

PavelR's avatar
PavelR
Solution Specialist
9 years ago

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's avatar
Rasmusrock
Helper II
9 years ago

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