cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

Custom Column - handle comparing multiple null columns

I have 15 columns. I want to create a custom column that checks if all 15 columns are not NULL to output either Complete or Incomplete

 

My logic is something like:

=

[ID] = null
or [NAME] = null
or [Application] = null
or [Application Type] = null
etc etc
then "Incomplete"
else "Complete"
 
But I always get Incomplete even though there are multiple rows with everything filled in.
 
Any ideas on how to structure that logic?
1 ACCEPTED SOLUTION

Hi @Anonymous,

 

with the function ISBLANK you can check if there is any value.

 

BLNK =
VAR AnyBlank =
    ISBLANK ( TestTable[Column1] ) || ISBLANK ( TestTable[Column2] )
        || ISBLANK ( TestTable[Column3] )
VAR Result =
    IF ( AnyBlank; "Incomplete"; "Complete" )
RETURN
    Result

 

Annotation 2019-02-25 201947.jpg

View solution in original post

9 REPLIES 9
Anonymous
Not applicable

Can you post some sample data? 

 

Anonymous
Not applicable

Nick, I attached the sample table and sample formula i'm using

Hi @Anonymous,

 

please check the 3rd message of this thread if it is the solution you expect. We published our post in the same time and maybe it was overseen.

Anonymous
Not applicable

Logically that looks perfect but a followup question is where would I input that logic?

 

I created a custom column and then I get this Custom Column prompt which I'll attach below. Within this prompt, I get errors trying similar logic as you posed to I'm guessing that I'm not entering the information in the right area?

 

samplecode2.PNG

Hi @Anonymous ,

 

in PowerBI in tab Modeling click on New Column. And then insert the DAX code I've sent you.

 

Annotation 2019-02-25 212201.jpg

Anonymous
Not applicable

Ah there we go. Thank you and I accepted the solution

Great to hear about that Smiley Happy

Anonymous
Not applicable

sample code.PNGsample data.PNG

Hi @Anonymous,

 

with the function ISBLANK you can check if there is any value.

 

BLNK =
VAR AnyBlank =
    ISBLANK ( TestTable[Column1] ) || ISBLANK ( TestTable[Column2] )
        || ISBLANK ( TestTable[Column3] )
VAR Result =
    IF ( AnyBlank; "Incomplete"; "Complete" )
RETURN
    Result

 

Annotation 2019-02-25 201947.jpg

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors