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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

DAX IF statement insert NULL value

I need to build a calculated column (numeric data type) using IF statement and I need to insert "null" value if condition is met. How to do it in DAX please?

If I use: Score = if('Key Measures'[Score A]=0;"null";'Key Measures'[Score A])  or Score = if('Key Measures'[Score A]=0;"";'Key Measures'[Score A]) 

I get error: Expressions that yield variant data-type cannot be used to define calculated columns.

Which is obvious because I mix numeric and text data types.

 

But how can I insert null/blank value to the cell using DAX? Insert 0 is not solution for me in this case 😞

1 ACCEPTED SOLUTION
andris_
Resolver I
Resolver I

Hey,

 

I'm not sure what the result is that you'd like to get, but with the following formula, you can get blank values :
Score A = if('Key Measures'[Score A]=0;BLANK();'Key Measures'[Score A]) 

 

 

Regards,

Andris

View solution in original post

4 REPLIES 4
andris_
Resolver I
Resolver I

Hey,

 

I'm not sure what the result is that you'd like to get, but with the following formula, you can get blank values :
Score A = if('Key Measures'[Score A]=0;BLANK();'Key Measures'[Score A]) 

 

 

Regards,

Andris

Anonymous
Not applicable

OK, I knew that it was going to be simple, but so simple...

Thank you very much, Andris.

miltenburger
Helper V
Helper V

Hi @Anonymous

 

See this post before, same thing. Should work in your scenario

https://community.powerbi.com/t5/Desktop/How-to-define-the-value-of-a-cell-to-NULL-in-a-quot-IF-quot/m-p/25086

 

Anonymous
Not applicable

Yes, I checked that post already, but that is not my case. That guy needs to count something.

But I need just to insert null (I need empty cell).

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.