Forum Discussion

Regulate's avatar
Regulate
Regular Visitor
8 years ago
Solved

Maximum date difference between consecutive purchases for a customer

Hi!   I am having troubles with calculating the maximum difference between two consecutive purchases for each customer. Note that this is not the same as date difference between first and last purc...
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Regulate

 

You can use this column in the Customers Table

 

Max_diff_between_Purchase =
VAR temp =
    CALCULATETABLE ( VALUES ( Purchase_table[PurchaseDate] ) )
VAR temp1 =
    ADDCOLUMNS (
        temp,
        "Days", DATEDIFF (
            [PurchaseDate],
            MINX (
                FILTER ( temp, [PurchaseDate] > EARLIER ( [PurchaseDate] ) ),
                [PurchaseDate]
            ),
            DAY
        )
    )
RETURN
    MAXX ( temp1, [Days] )