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
BBIUser
Helper IV
Helper IV

How to handle NULL in a Custom Column?

Hi,

 

I have this one Custom Column "Notable Change?" value as 'Error'. I need to display it as 'None' instead. 

How do I handle null in the below formula? Sample screenshot is below and Error is highlighted in Red.

 

Here is the Custom Column formula:

=if [cCount]>0 and [ThreeYrAvg]>0 and 
([cCount] - [ThreeYrAvg]>=5.0) and 
((([cCount] * 1.00 - [ThreeYrAvg]) / [ThreeYrAvg]) * 100) >= 10.00
then "Increase"

else if [cCount]>0 and [ThreeYrAvg]>0 and 
([cCount] - [ThreeYrAvg]<=-5.0) and
((([cCount] * 1.00 - [ThreeYrAvg]) / [ThreeYrAvg]) * 100) <= -10.00
then "Decrease"

else if ([cCount]>0 and [ThreeYrAvg] = null) 
then "none"

else "None"

Here is how the sample data looks like -

2018-10-24_1103.png

 

Appreciate your help. Thanks!

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@BBIUser,

 

Just move the condition below to the first.

[ThreeYrAvg] = null
Community Support Team _ Sam Zha
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

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@BBIUser,

 

Just move the condition below to the first.

[ThreeYrAvg] = null
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-chuncz-msft. That works neat!

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.