I want to write a measure in PowerBI (DAX) to compare data within the same table.

I am looking for a DAX formula that checks whether a ContactID has an AppointmentType A and an AppointmentType B. The condition is that AppointmentType B needs to be on the same day or after Appointment A, but not more then 3 months.

enter image description here

The formula should return the number of matches. In the example table it should return 1 since only ContactID 002 meets the criteria.

New contributor
Ronald Knetsch is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • 1
    Can you post some of the DAX you've tried? – StelioK Jun 12 at 15:33

Your Answer

Ronald Knetsch is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.