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
GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi Anonymous,


I would suggest creating the column in the query editor.


In doing so you can use the TRIM function to ensure that there are no leading or trailing spaces.

You can then also potentially use the Captilize Each Word, or Lowercase to ensure that all the values are the same (NOTE: The data in the Query Editor is Case Sensitive)

 

You can then add a conditional column, which will then load into your Model.

 

As well as not only will your model be more efficient, but it is also easier to create the columns in the Query Editor.