DAX IF function syntax error- creating a conditional column

Question

I've got a csv with 900,000 rows. 42 of them are duplicates. PQ's Remove Duplicates function removes rows that aren't true dupes.

I can successfully filter for these 42 rows in the PQ Editor, but I can't figure out how to remove them (can't select more than one).

The dupes are ones that have a null birthdate and 7/17/1989 registration date. Both of those columns are date format.

I'm trying to instead add a conditional column with this formula: =IF(AND(ISBLANK[Voters_BirthDate]), [Voters_OfficialRegDate]= "7/17/1989")), "Y", " ")

but I'm getting a syntax error "The syntax for ',' is incorrect." It's referring to the comma before "Y", but that comma should be there, right?

I think you're missing an open-parentheses for ISBLANK. Annnd ... you have four ) but only two (. So you're missing another (. — Denton Thomas
– Denton Thomas, Commented Mar 9, 2024 at 16:03

Denton Thomas · Accepted Answer · 2024-03-09 16:11:09Z

1

Urgh, nested formulas. I think this is right:

=IF(AND(ISBLANK([Voters_BirthDate]), ([Voters_OfficialRegDate]= "7/17/1989")), "Y", " ")

answered Mar 9, 2024 at 16:11

Denton Thomas

3981 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lillian Welsh · Accepted Answer · 2024-03-09 16:22:02Z

0

Turns out I was just missing an open parenthesis after ISBLANK

answered Mar 9, 2024 at 16:22

Lillian Welsh

391 silver badge4 bronze badges

Collectives™ on Stack Overflow

DAX IF function syntax error- creating a conditional column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related