Forum Discussion

kkane's avatar
kkane
Regular Visitor
3 years ago

DAX IF OR ISBLANK

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?

2 Replies

  • djurecic's avatar
    djurecic
    Icon for Super User rankSuper User
    3 years ago

    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"

  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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
)