DAX IF OR ISBLANK

kkane · ‎12-02-2022

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?

ERD · ‎12-03-2022

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

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Stand with Ukraine!

Here is an official way you can support Ukraine financially:
Come Back Alive foundation: https://savelife.in.ua/en/
Thank you!

djurecic · ‎12-02-2022

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"