Forum Discussion
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...
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
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
OK, I knew that it was going to be simple, but so simple...
Thank you very much, Andris.