Forum Discussion
Datediff in DAX
I have multiple ticket ids of an order, now I want to find out if those ticket ids occur 3 or more times within 30 days. Can anyone suggest? columns are ticket_id and Dispactch_date.
Edit 1: I can not share the data but will provide as much info possible.
I only have 1 table that consists of everything. There is a ticket_id (numerical) and dispatch date (ddmmyy hrs min sec) format and has data of one year. I want ticket_ids as output that have been dispatched 3 or more times within 30 days. These could be any 30 days and not necessarily month to month.