topic DAX IF OR ISBLANK in DAX Commands and Tips

DAX IF OR ISBLANK

kkane — Fri, 02 Dec 2022 17:58:07 GMT

Hi,

Struggling with the below. Getting a response saying there are too many arguments. Basically, I want to be able to filter my data by one row per client. Right now I'm getting a row for every contact so same client is appearing 10 or more times.

Clientbase = IF(OR(vw_contacts[Actual_Appt_Date]=(vw_contacts[LastAppointment]),(ISBLANK(vw_contact[Actual_Appt_Date])),"1"))

What am I doing wrong?

Re: DAX IF OR ISBLANK

djurecic — Fri, 02 Dec 2022 21:38:46 GMT

Hi kkane ,

Can you explain the logic you are trying to use? Right now, the true part of the If statement is ISBLANK(vw_contact[Actual_Appt_Date]) which returns true/false, and the false part of the If statement is "1"

Re: DAX IF OR ISBLANK

ERD — Sat, 03 Dec 2022 09:05:15 GMT

kkane , without data sample and required result it's hard to analyze the formula. As for the syntax mistakes, formatting helps to see redundant brackets.

Clientbase = IF ( OR ( vw_contacts[Actual_Appt_Date] = vw_contacts[LastAppointment], ISBLANK ( vw_contact[Actual_Appt_Date] ) ), 1 )