Help finding if a date is within a date range

[Douttful]

Hello! 

I work in a call center, and we have a system for grading tickets to ensure quality of service expectations are being met. These tickets are supposed to be graded within a week of being assigned. I am trying to write a querey to determine if a ticket was or was not graded in that time period. The end goal is that if it was not that it returns the ticket number and time it was graded, but I feel like that would be better as a measure. 

I've gotten this far based on similar date range issues and my limited experience : 

Grading Adherence =

CALCULATE(VALUES('Grading Schedule Adherence Data'[Graded QA Ticket Data.Time Ticket Graded].[Date]),

FILTER('Grading Schedule Adherence Data', 'Grading Schedule Adherence Data'[Date Assigned].[Date]<= EARLIER('Grading Schedule Adherence Data'[Graded QA Ticket Data.Time Ticket Graded].[Date])&& 'Grading Schedule Adherence Data'[Due Date]>=EARLIER('Grading Schedule Adherence Data'[Graded QA Ticket Data.Time Ticket Graded].[Date])))

BUT the code errors out for me. 

This is an example of my table. 

Assignee	Date Assigned	Graded QA Ticket Data.Time Ticket Graded	Graded QA Ticket Data.Point	Ticket Numer	Due Date
Mouse	Saturday, January 22, 2022	1/22/2022 20:53	Mickey Mouse	INC000001954853	1/30/2022 0:00
Mouse	Saturday, January 22, 2022	1/22/2022 20:52	Mickey Mouse	INC000001957522	1/30/2022 0:00
Mouse	Saturday, January 22, 2022	1/22/2022 20:51	Mickey Mouse	INC000001955258	1/30/2022 0:00
Mouse	Saturday, January 22, 2022	1/22/2022 20:49	Mickey Mouse	INC000001956219	1/30/2022 0:00
Mouse	Saturday, January 22, 2022	1/22/2022 20:49	Mickey Mouse	INC000001952437	1/30/2022 0:00
Mouse	Saturday, January 22, 2022	1/22/2022 20:48	Mickey Mouse	INC000001955320	1/30/2022 0:00
Mouse	Saturday, January 22, 2022	1/22/2022 20:47	Mickey Mouse	INC000001957094	1/30/2022 0:00
Mouse	Saturday, January 22, 2022	1/22/2022 20:46	Mickey Mouse	INC000001958121	1/30/2022 0:00
Mouse	Saturday, January 22, 2022	1/22/2022 20:45	Mickey Mouse	INC000001954616	1/30/2022 0:00

I appreciate anyone who is willing to help! Thanks so much for your time!!! 

[TheoC · Accepted solution]

Hi @Douttful 

You can try create a Calculated Column using the following:

Column = IF ( Table[Due Date] is <= Table[Graded] , "Accept" , "After Due Date" )

I hope that my undersatnding of what you are wanting is correct. If not, let me know!

Thanks heaps,

Theo 🙂

[Douttful]

@TheoC Thank you! I had to change it to 

Column = IF ( Table[Due Date] is >= Table[Graded] , "Accept" , "After Due Date" ) 

But after that it worked! I was over complicating it a lot. Thanks SO much!!!!! 

[TheoC]

My bad lol!  Glad to hear you got it working. All the best with everything 🙂