Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

IF AND formula for Conditional Column

I am trying to create a column that does something like the following:   IF cell in [TextColumn] = "value" AND cell in [DateColumn] is empty THEN "value2" ELSE do nothing   What would a dax forum...
Need Help
vega's avatar
vega
Resolver III
8 years ago
Column = 
IF(
    Table1[TextColumn] = "value" && ISBLANK(Table1[DateColumn]),
    "value2",
    BLANK()
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

vega Thanks for the reply! When I use your formula I get the error "Token Literal expected." When I click "show error" the second ampersand is highlighted (&&)