Forum Discussion
Dax tekst function
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) ?
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 !
1 Reply
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 !