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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
Peekay_Num
Helper I
Helper I

Multi Condition M using AND Operator

I'm creating a custom column.  I have 3 fields [FieldA, [FieldB], [FieldC],  I'm trying to write a conditional clause that produces a value if they are all e fields null else another if any of them aren't Null

 

each if ([FieldA] = "" and [FieldB] = "" and [FieldC] = "") then "All are null" else "Not null"

 

This isn't producing any syntax errors.  When it runs it assigns every value in the new column to "Not null".  I know there are hundreds of rows where all 3 fields are null so this is incorrect.  I'm so close..  I've tried ISBLANK, it doesn't like it.  How can I do this ?

1 ACCEPTED SOLUTION
spinfuzer
Solution Sage
Solution Sage

instead of  ="" use =null

View solution in original post

2 REPLIES 2
Peekay_Num
Helper I
Helper I

That worked , Thank you !

spinfuzer
Solution Sage
Solution Sage

instead of  ="" use =null

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.