Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Starts with containing wildcard

I have column A with text, column B with text.   I want to add a conditional column like this   =if(column A starts with "W" and column B starts with "W", "True", "False")
Need Help
  • mede's avatar
    mede
    9 years ago

     

    If you are trying in DAX, have you tried this:

      

    Column C = IF(LEFT(Table1[Column A],1)="W" && LEFT(Table1[Column B],1)="W",TRUE(),FALSE())

     

mede's avatar
mede
Icon for Resolver I rankResolver I
9 years ago

 

If you are trying in DAX, have you tried this:

  

Column C = IF(LEFT(Table1[Column A],1)="W" && LEFT(Table1[Column B],1)="W",TRUE(),FALSE())