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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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