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.
amitchandak
Super User
Super Userishanjain , Join Dispactch_date with date calendar
ant try a measure like this
Rolling 30 day = CALCULATE(count(ticket [ticket Id]),DATESINPERIOD('Date'[Date],MAX(ticket[Dispactch_date]),-30,Day))
Rolling 30 day = CALCULATE(count(ticket [ticket Id]),DATESINPERIOD('Date'[Date],MAX('Date'[Date),-30,Day))
You can use this in Sumx or countx filter of at visual filter
link countX(filter(summarize(ticket,ticket [ticket Id],"_1", CALCULATE(count(ticket [ticket Id]),DATESINPERIOD('Date'[Date],MAX('Date'[Date),-30,Day)) ),[_1]>3),[ticket Id])