Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX for IF formula

Need help with simple DAX formula. DAX will go in Column B. If The adjacent cell in Column A is not blank, then place a 1 in the adjacent cell in Column B. Thanks for any help!
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous 

     

     

    Column_B= 
IF(Table[COLUMN_A] = BLANK(), BLANK(), 1)

OR 

Column_B= 
IF(LEN(Table[COLUMN_A])=0, BLANK(), 1)

OR

Column_B= 
IF(ISBLANK(Table[COLUMN_A]), BLANK(), 1)

     

    Did I resolve your issue? Mark my post as a solution!

     

    Appreciate your Kudos, Press the thumbs up button!!

     

    Regards,
    Pranit

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous 

 

 

Column_B= 
IF(Table[COLUMN_A] = BLANK(), BLANK(), 1)

OR 

Column_B= 
IF(LEN(Table[COLUMN_A])=0, BLANK(), 1)

OR

Column_B= 
IF(ISBLANK(Table[COLUMN_A]), BLANK(), 1)

 

Did I resolve your issue? Mark my post as a solution!

 

Appreciate your Kudos, Press the thumbs up button!!

 

Regards,
Pranit

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks this worked perfect!