Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to write these condition in conditional column and add column
=IF(AND(A2<A3, A2<100), A2, "The value is out of range")
Solved! Go to Solution.
you should create calculation column:
calculation column name =IF(AND([column A2]<[column A3], [column A2]<100), [column A2], "The value is out of range")
if I answered at your question please mark topiс as resolved 🙂
Thank you very much!
Can we also implement other Excel functions like ISERROR, MATCH, AND, OR etc
@amanuit , Please check the reply from @SolomonovAnton first
Then try
IF(AND(A2<A3, A2<100), A2, "The value is out of range")
or
IF( A2<A3 && A2<100 , A2, "The value is out of range")
hello !
first of all I think you have error in this expression
=IF(AND(A2<A3, A2,100), A2, "The value is out of range")
what do you want to say in it expression AND(A2<A3, A2,100) ?
Edited, this is excel equation and want to implement same in Power BI.
you should create calculation column:
calculation column name =IF(AND([column A2]<[column A3], [column A2]<100), [column A2], "The value is out of range")
where can i find Calculation column option, is it same like custom calculation?
if I answered at your question please mark topiс as resolved 🙂
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |