Days between duplicates

Hi,

Please check the below.

It is for creating a new measure.

Days from previous order: =
VAR currentserial =
MAX ( Data[Serial] )
VAR currentordernumber =
MAX ( Data[Order num] )
VAR currentdate =
MAX ( Data[Repair completed] )
VAR previousdate_sameserial =
MAXX (
FILTER (
ALL ( Data ),
Data[Serial] = currentserial
&& Data[Order num] < currentordernumber
),
Data[Repair completed]
)
RETURN
IF (
HASONEVALUE ( Data[Order num] ),
IF (
ISBLANK ( previousdate_sameserial ),
"N/A",
INT ( currentdate - previousdate_sameserial )
)
)