Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

column condition if else

Hello  Column will always three values , " Y", "N","Null" . I did sample calculated column in dax  if colum1 = 'Y', 'N', but how do i look for "null" value also if  two values (y&N) not found.   ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    it depends on what exactly null do you have.

    if you have "null" as text compare it with null in quotas:

    IF([Column1] = "Null", 1, 0)

    if you have null as blank field try ISBLANK()

    IF(ISBLANK([Column1]), 1, 0)

    or BLANK()

    IF([Column1] = BLANK(), 1, 0)

    so, your full statement if you have both nulls in data:

    SWITCH(TRUE(),
[Column1] = "Y", "Y value",
[Column1] = "N", "N value",
[Column1] = "Null", "Null as text value",
[Column1] = BLANK(), "Null as blank value",
"any other value"
)