Forum Discussion

Messy92's avatar
Messy92
New Member
8 years ago
Solved

IF statement problem

Hello! I wanted to ask you something  if i have a mobile phone column, a home phone column and a other phone column How can i create a new column where  i say that if there is at least a number...
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi Messy92,

     

    Please refer to following sample, see if it works for you:

     

    Flag =
IF (
    (
        IF ( ISBLANK ( Phones[mobile phone] ), 0, 1 )
            + IF ( ISBLANK ( Phones[Home phone] ), 0, 1 )
            + IF ( ISBLANK ( Phones[other phone] ), 0, 1 )
    )
        >= 1,
    1,
    0
)

     

    Thanks,
    Xi Jin.

leslieangelia's avatar
leslieangelia
Frequent Visitor
8 years ago

If you are doing this in the query editor rather (create a column) rather than in dax (create a measure) there is a built in feature that does not require you to know M.

 

You go to Add Column --> Conditional Column and then set your rules. 

if mobile phone column does not equal null, then 1

else if home phone does not equal null, then 1

else if other phone does not equal null, then 1

else 0