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



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
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 !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! 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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.