Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
kkane
Regular Visitor

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 2
ERD
Community Champion
Community Champion

@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.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!


Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/

Thank you!

djurecicK2
Super User
Super User

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"

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.