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'[Scor...
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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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