Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 :-(

Need Help
  • andris_'s avatar
    andris_
    8 years ago

    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

4 Replies