DAX to find all inactive id in 3 month

[Twe-Maker]

DAX to find all inactive ItemID over -3 month. ItemID which havent move OUT in -3 month (ill make into field parameter 6/12/24/36 month).

ID	ItemID	Status	Date
8	101	OUT	20/07/22
7	102	IN	15/07/22
6	106	OUT	15/07/22
5	105	OUT	null
4	106	IN	05/05/22
3	101	OUT	28/03/22
2	103	OUT	24/02/22
1	102	IN	15/02/22

ItemID	#Days
102	155
103	146
105	null

Something I try.....
inactive_device_6m =

VAR _CurrentDate = MAX('DateTable'[Date])

VAR _6MonthsAgo = EOMONTH(_CurrentDate, -6)

VAR _ActiveItem6Month =
???
VAR _InactiveItemOver6Month =
???
Return
?? #DaysITEMHaventOut

maybe #day(inactive_item)

#days =
VAR
NumberOfDays =
MAX('DateTable'[Date]) -
'table'[Date]
RETURN
IF(
ISBLANK('table'[date]);
BLANK();
NumberOfDays
)

Im new to Power bi and Thank You.

[amitchandak · Accepted solution]

@Twe-Maker , Create measures like

Rolling 3 = CALCULATE(countrows(filter(Table, Table[Status]="OUT")), DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))

Not out = countx(values(table[item ID]), if (Isblank([Rolling 3]), [item id], blank()  ) )

[Twe-Maker]

Thank you