- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
IF AND formula for Conditional Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-11-2018 10:02 AM
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?
Re: IF AND formula for Conditional Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-11-2018 10:45 AM
Column = IF( Table1[TextColumn] = "value" && ISBLANK(Table1[DateColumn]), "value2", BLANK() )
Re: IF AND formula for Conditional Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-11-2018 10:58 AM
@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 (&&)
Re: IF AND formula for Conditional Column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-11-2018 11:07 AM
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?