Conditional column-IFAND function

[amanuit]

How to write these condition in conditional column and add column

=IF(AND(A2<A3, A2<100), A2, "The value is out of range")

[SolomonovAnton · Accepted 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")

[SolomonovAnton · Accepted solution]

there are description https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns

[amanuit]

Thank you very much!

[amanuit]

Can we also implement other Excel functions like ISERROR, MATCH, AND, OR etc

[amitchandak]

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

[SolomonovAnton]

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

[amanuit]

Edited, this is excel equation and want to implement same in Power BI.

[SolomonovAnton · Accepted 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")

[amanuit]

where can i find Calculation column option, is it same like custom calculation?

[SolomonovAnton · Accepted solution]

if I answered at your question please mark topiс as resolved 🙂

[SolomonovAnton · Accepted solution]

there are description https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns