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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ERing
Post Partisan
Post Partisan

How to handle null in custom column?

I have a simple custom column below that is a conversion time in dates. Each of these columns has rows with null, so my custom column also has null. Is there a way I can replace null with blank in my custom column?

column = [lead duration] - [offer duration] - [accepted duration]

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @ERing ,

 

Unfortunately, this is the default. null means blank. null does not represent the text "null" here, so it does not affect the calculation.

vstephenmsft_0-1696319785311.png

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @ERing ,

 

Unfortunately, this is the default. null means blank. null does not represent the text "null" here, so it does not affect the calculation.

vstephenmsft_0-1696319785311.png

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

mlsx4
Memorable Member
Memorable Member

Hi @ERing 

 

You can establish an if to check if a value is null. I don't know how your columns are defined, but anyway: if([lead duration]= null then <what you want to return> else [lead duration])

 

If you want a blank -> then BLANK()

My columns are defined as decimal number.

 

Is there a way to check just the result of the custom column so that if the result is null, then Blank()?

mlsx4
Memorable Member
Memorable Member

Hi @ERing 


Yes, you can store the result in a variable and then check with an if in this way:

 

 

 

 

Measure=

var _result= <Your measure>

return IF (_result= null,BLANK(),_result)

 

 

But if you want to perform calculus, it is better to return a 0 instead of a BLANK()

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.