Getting previous date by category, not min date

Thanks for clearer explanation, below you can try the new measure for the different of the days compare to previous ID.

Measure =

var forid = SELECTEDVALUE('Table'[ID])

var selectdate = SELECTEDVALUE('Table'[Date])

var previousdate = CALCULATE(MAX('Table'[Date]),FILTER(ALL('Table'),'Table'[ID]=forid-1))

var result = DATEDIFF(previousdate,selectdate,DAY)

return

IF(previousdate=BLANK(),BLANK(),result)

Another measure is the status: 

Status =

var forid = SELECTEDVALUE('Table'[ID])

var forcategory = SELECTEDVALUE('Table'[Category])

var result = CALCULATE(MAX('Table'[Category]),FILTER(ALL('Table'),'Table'[ID]=forid-1))

return

IF(result=BLANK(), BLANK(), IF(forcategory<>result, "Change", "No Change"))

 

 

 

Hope this can help you.

 

Hi Anonymous 

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry