cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amanuit
Regular Visitor

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

 
3 ACCEPTED SOLUTIONS

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

 

View solution in original post

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

View solution in original post

9 REPLIES 9
amanuit
Regular Visitor

Thank you very much!

amanuit
Regular Visitor

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

amitchandak
Super User
Super User

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



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!
SolomonovAnton
Responsive Resident
Responsive Resident

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 🙂

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors