Forum Discussion

Regular Visitor

4 years ago

Solved

Conditional column-IFAND function

How to write these condition in conditional column and add column =IF(AND(A2<A3, A2<100), A2, "The value is out of range")

4 years ago

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")

SolomonovAnton
4 years ago
there are description https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns
SolomonovAnton
4 years ago
if I answered at your question please mark topiс as resolved 🙂

Icon for Super User rank

Super User

4 years ago

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")

Related content