Forum Discussion

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

Text functions DAX

Hi Guys,    im looking for a method to achieve the following.  I have 2 columns. the first colomn contains names (name) and the other colums countries (country).   Now im looking to make anoth...
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi 01_RAF_01 

    can you please try

    if(Table[Country] in {'USA','FR'}, 

                if(LEFT(Table[name],1) in {'m','n','o','p','q','r','s','t','u','v','w','x','y','z'},"YES","YESSS"),"NO")

           

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi 01_RAF_01 

can you please try

if(Table[Country] in {'USA','FR'}, 

            if(LEFT(Table[name],1) in {'m','n','o','p','q','r','s','t','u','v','w','x','y','z'},"YES","YESSS"),"NO")

       

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

    thanks Anonymous it worked. I thought maybe there was a solution to look for the whole combination of letters without typing them all seperate. any idea if there is a solution for that?