Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 date the appointment is made, so there is a person column, appointment ID, appointment date, appointment confirmed date columns;
Patient | appointment_ID | Appointment_Date | Appointment_Confirm |
1 | 1000 | 01/01/2020 | 01/01/2020 |
1 | 1001 | 01/02/2020 | 03/04/2020 |
2 | 2001 | 01/03/2020 | 01/03/2020 |
3 | 2050 | 01/03/2020 | null |
4 | 2075 | 01/03/2020 | 10/03/2020 |
I want a formula that will show in a graph the unconfirmed appointments by date, so for 01/03/2020 there would be 3 unconfirmed appointments.
Really struggling with the DAX to get this right so any help would be greatly appreciated
Thanks
Solved! Go to Solution.
@mik618 , Refer article on a similar topic. The current employee is you pending confirmation
@mik618 , Refer article on a similar topic. The current employee is you pending confirmation
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])
)
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |