Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JChart
Regular Visitor

IF AND 3 Conditions

First post and I'm hoping you are able to help.

 

I am trying to build a conditoinal statement using 3 separate fields of data, but I'm not sure how to achieve this.

 

In a perfect world, I could use IF(AND(Logical1,Logical2),"True","False"). I could then enter each conditional statement for each logical component, but I can only use 2 arguments.


What is the best function to use for 3 logical arguments?

 

i.e. 

if Field1 = "X", and Field2 = "Y", and Field3 > Z,  "True","False"

 

Thanks!

 

 

1 ACCEPTED SOLUTION
CrisYan
Resolver III
Resolver III

IF(Field1 = "X" && Field2 = "Y" && and Field3 > Z, "True","False")

View solution in original post

1 REPLY 1
CrisYan
Resolver III
Resolver III

IF(Field1 = "X" && Field2 = "Y" && and Field3 > Z, "True","False")

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.