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

andris_'s avatar
andris_
Resolver I
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

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

    Thank you very much, Andris.