Forum Discussion

mik618's avatar
mik618
Icon for Helper I rankHelper I
6 years ago
Solved

active at certain times

Hi there,    I've been asked to do various reports looking at improvment and display this in a graph, one report is looking at confirming appointments, every appointment should be confirmed the dat...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

Hello mik618 

Wouldn't it be 2 unconfirmed on 1/3?  Appointment 2001 the dates match.  Anyway, something like this should get you the count of rows where it doesn't match.

Unconfirmed Count = 
COUNTROWS(
    FILTER (Appointments, Appointments[Appointment_Date] <> Appointments[Appointment_Confirm])
)
mik618's avatar
mik618
Icon for Helper I rankHelper I
6 years ago

Hi jdbuchanan71 

 

Thanks for helping, it would be 3 unconfirmed at this date as id 1001 would still be outstanding, thats the problem I'm having it needs to be able to look at all unconfirmed appointments, not just the appointment dates, so we can look at any date in the last year or so and see how many were outstanding at that time. 

 

Thanks 

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    6 years ago

    mik618 Is your table only the unconfirmed appointments?  If so you can do a COUNTROWS (YourTable), pull the appointment date into the chart and the measure into the values and see the unconfirmed appointments by date.