Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

is(isblank) function

i had below DAX, but its not working.  i've created a new column "company", company = "No" if account have no value otherwise "yes".    Company = if(ISBLANK('RER 2016'[Account]),"No", "Yes")   bu...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

You probably have an empty space in the column rather than a blank()

 

try

Company = if(ISBLANK('RER 2016'[Account]) || 'RER 2016'[Account]=""  ,"No", "Yes")