Forum Discussion

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago
Solved

BLANK greater than an integer?

Hi all,   Can anyone confirm that a BLANK value is computed as greater than a value?  I have a measure which compares two values, to be used in conditional formatting. My surprise arises when I se...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    PaulDBrown 

     

    In Dax Blank equivalent to Zero only when the data type is Numbers. 

    For other data types(Date, Text), a blank is just a blank. 

    Paul Zheng
    Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PaulDBrown 

 

In Dax Blank equivalent to Zero only when the data type is Numbers. 

For other data types(Date, Text), a blank is just a blank. 

Paul Zheng
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

PaulDBrown's avatar
PaulDBrown
Community Champion
6 years ago

az38 edhans Anonymous 

 

Thanks everyone for looking into this. It makes sense (sort of... intuitively I assumed that a blank was a no-value) and goes to show that you learn new things every day. 

I solved it easily using an IF statement combined with ISBLANK.  

All the best toyou all!