Forum Discussion
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 in any of these columns then write me 1 or if there is any numbers in these columns then write me 0.
Thank you so much, sorry for my english im italian and im starting now to discover power bi :smileyhappy:
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.
3 Replies
See this page for help:
https://msdn.microsoft.com/en-us/query-bi/dax/if-function-dax
The syntax for one if statement is this: IF(logical_test>,<value_if_true>, value_if_false)
If you have more than one check - which you do - then you need something more like this example - which is also from the page above:
=IF([Calls]<200,"low",IF([Calls]<300,"medium","high"))
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
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.
