topic Re: Date Difference based on a column filter in DAX Commands and Tips

Date Difference based on a column filter

mgaut341 — Mon, 21 Jul 2025 14:53:30 GMT

I was able to get my date difference custom column, however I need it to take into account the type of service provided if there are multiple chart numbers.

My current formula is:

Wait Times = DATEDIFF('CCHHS Mammo'[Date Referred], 'CCHHS Mammo'[Appointment],MONTH)

However, it is providing a date difference for chart number 23549 diagnostic service even though it doesnt have an appt date, since it is taking the appt date from 23549 US Breast service.

How should I fix my formula to incorporate the service being provided?

Re: Date Difference based on a column filter

bhanu_gautam — Mon, 21 Jul 2025 15:02:41 GMT

mgaut341 , Try using

Wait Times =
IF('CCHHS Mammo'[Service] = "Diagnostic",
DATEDIFF('CCHHS Mammo'[Date Referred], 'CCHHS Mammo'[Appointment], MONTH),
IF('CCHHS Mammo'[Service] = "US Breast",
DATEDIFF('CCHHS Mammo'[Date Referred], 'CCHHS Mammo'[Appointment], MONTH),
NULL
)
)

Re: Date Difference based on a column filter

mgaut341 — Mon, 21 Jul 2025 15:19:14 GMT

Thank you!