Measure to see if the previous date is greater then 3 months based on id

[Anonymous]

Hi Experts

need a measure that would count where a Date had been extended out by more then 3 months where issues ID has remained the same in the second column. 

DATE              ISSUE ID          Result

01/01/21        50

01/05/21        50                    Extended

01/02/21        25

01/03/21        25                    No Change

[RohiniP-26]

@Anonymous 

you can try this dax

result =

IF(ISBLANK(CALCULATE(MAX(Sheet1[Date]),FILTER(Sheet1,Sheet1[Issue id]=EARLIER(Sheet1[Issue id]) && Sheet1[Date]<EARLIER(Sheet1[Date])))), BLANK(),

IF(DATEDIFF(CALCULATE(MAX(Sheet1[Date]),FILTER(Sheet1,Sheet1[Issue id]=EARLIER(Sheet1[Issue id]) && Sheet1[Date]<EARLIER(Sheet1[Date]))), Sheet1[Date],

MONTH

)>3,

"EXTENDED",

"NO CHANGE"

)

)

If you want to count all issue id which are extended then use below measure,

count = CALCULATE(COUNT(Sheet1[result]),FILTER(Sheet1,Sheet1[result]="EXTENDED"))

If this post helps you mark it as 'Accept as solution' below

[amitchandak · Accepted solution]

@Anonymous , Try measure like

if( datediff(Max(Table[Date]) , MAXX(filter(allselected(Table), Table[ID] = Max(Table[ID]) && Table[Date] < Max(Table[Date])),[Date]), month) >4, "Extended", "No Change")