Forum Discussion
Solved
IF statement for value 0
I need to be able to differentiate 0 vs blank values in a DAX formula. I've tried using ==0 for the number 0 and ="" for blanks, but == seems so be giving error in my DAX formula. How do I make thi...
"==" is not supported in Excel. How to handle blanks is here Handling BLANK in DAX - SQLBI
Back to your case. BLANK()=0 returns TRUE, but ISBLANK(0) returns FALSE. Thus formula could be
Please check in attached file.
"==" is not supported in Excel. How to handle blanks is here Handling BLANK in DAX - SQLBI
Back to your case. BLANK()=0 returns TRUE, but ISBLANK(0) returns FALSE. Thus formula could be
Please check in attached file.
- Thank you. Is there some similar solution if I want to exclude value 0 but keep blanks with an advanced filter.
I've tried amount: <>"0"
