I am trying to work the number of appointments between 2 dates.
The issue arises if the staff member has changed the amount of days worked.
What I want to do is for Staff member ‘J’, I want it to calculate Target Appts between the start and the end date and if no end date exists return Target Appts on or after start date
I’ve reviewed the Time Intelligence course but unable to figure out
This is what I have so far
Target Appts = SUMX ( SUMMARIZE ( 'Access Active Advisers', 'Access Active Advisers'[Adviser], "Expected Appts", [Predicted Adviser Appt] ), [Expected Appts] ) Appts = CALCULATE ( [Target Appts], FILTER ( VALUES ( Dates[Date] ), COUNTROWS ( FILTER ( 'Access DB Adviser Appt Target', Dates[Date] >= 'Access DB Adviser Appt Target'[Start] && Dates[Date] <= 'Access DB Adviser Appt Target'[End] ) ) ) )