DAX IF statement insert NULL value

[Anonymous]

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 😞

[andris_ · Accepted solution]

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]

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

Thank you very much, Andris.

[miltenburger]

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]

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).