Jun 23 2021 09:19 AM
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 this work? Attached a simplified dummy file, but with the same problem scenario.
DAX that gives no errors:
=IF(C5=0, "order more", IF(C5 ="", "unavailable", "OK"))
What I would like to do but can't get to work:
=IF(C5==0, "order more", IF(C5 ="", "unavailable", "OK"))
Jun 23 2021 09:36 AM
Solution"==" 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.
Jun 24 2021 01:02 AM
Jun 23 2021 09:36 AM
Solution"==" 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.