Dax tekst function

[01_RAF_01]

Hi Guys, 

was wondering is there is a method to search for specific tekstfunctions in DAX. 

For example if a column contains text. The text can contain different values. I only want to have a part of the tekst that starts for example with ABC. ( "this text is an example of ABC3424567 where i need a solution")

Is there a function to only have the text ABC3424567 showing (which always have 10 letter/numbers) ? 

[serpiva64 · Accepted solution]

Hi,

in your case i think you can use LEFT(<text>, <num_chars>) to create a calculated column

In text you insert the name of the column and 3 is your <num_chars>

RIGHT(<text>, <num_chars>) if you want to start from the end 

MID(<text>, <start_num>, <num_chars>) if you want to search inside the text

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !