Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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.
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.
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
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"))
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |