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...
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
)