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

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    That doesn't sound like DAX at all. Do you maybe mean Power Query? What have you tried so far?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Unfortunately I don't have permissions to do the edit in Power Query. Just trying to find a way to make the change in the data table. I just need to have a column populate 1 for every adjacent cell that is not blank. I need the "1's" to use as a count field since my table visual is not populating/counting all the data as it should.

      • lbendlin's avatar
        lbendlin
        Super User
        6 years ago

        is that computation something you only need to do once (calculated column) or can the result be impacted by filter choices (measure) ?  I guess the former?

  • 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!

  • VijayP's avatar
    VijayP
    Community Champion
    6 years ago

    Anonymous 

    assuming you are creating a new column and the name of the column you are pointing is  "SourceColumn"

    =If(ISBLANK([SourceColumn]), 0,1)

    Hope this Helps

    Vijay Perepa

    If you find this as solution please share kudos and mention this as solution.

    Thanks

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion
    6 years ago

    Anonymous 

     

    Try this DAX in the calculated column

    ColumnB = IF(NOT(ISBLANK('Table'[ColumnA])),1)