Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |