Reply
Regular Visitor
Posts: 16
Registered: ‎04-06-2018

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 forumla that accomplishes the above look like? 

 

Does it matter that the data in one column is text and the other is a date? 

Member
Posts: 105
Registered: ‎09-14-2017

Re: IF AND formula for Conditional Column

Column = 
IF(
    Table1[TextColumn] = "value" && ISBLANK(Table1[DateColumn]),
    "value2",
    BLANK()
)
Regular Visitor
Posts: 16
Registered: ‎04-06-2018

Re: IF AND formula for Conditional Column

@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 (&&

Highlighted
Member
Posts: 105
Registered: ‎09-14-2017

Re: IF AND formula for Conditional Column

Are you sure that you are using DAX? That formula works correctly as is if you are creating a calculated column in DAX. Are you trying to do the same thing that is being done here?