cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## DAX to find all inactive id in 3 month

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.

1 ACCEPTED SOLUTION
Super User

@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()  ) )

2 REPLIES 2
Super User

@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()  ) )

Frequent Visitor

Thank you