Forum Discussion

01_RAF_01's avatar
01_RAF_01
Frequent Visitor
4 years ago
Solved

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 ...
Need Help
Show and Tell
Tips and Tricks
  • serpiva64's avatar
    serpiva64
    4 years ago

    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 !

serpiva64's avatar
serpiva64
Solution Sage
4 years ago

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 !