cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Frequent Visitor

## Date difference customer orders

Hi,

I want to calculate the number of days between today and the last time a customer made a purchase order. I have a table with the purchase order nr as key and then the customer nr and purchase date. For every customer I want to know how long it has been since his last puchase. I tried to make a measure with the datedifference function but it never gives the correct result. Does anybody knows how to do this?

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: Date difference customer orders

@Sofie

Calculate Max Order Date Per Customer using ALLEXCEPT and then calculate Datediff with today.

Time Since Last Order Date =

Var LastOrderDt = CALCULATE(MAX('P6:TimeSinceLastOrder'[OrderDate]), ALLEXCEPT('P6:TimeSinceLastOrder','P6:TimeSinceLastOrder'[CustomerId]))

Var TimeSinceLastOrderDt = DATEDIFF(LastOrderDt,TODAY(),DAY)

RETURN TimeSinceLastOrderDt

3 REPLIES 3
Member

## Re: Date difference customer orders

Create this measure:

`Days Since Last Order = DATEDIFF(MAX(Sales[OrderDate]), TODAY(), DAY)`

Then use it in a table with the customer key or name

Frequent Visitor

## Re: Date difference customer orders

This does not seems to work if I try to adjust the current date

Established Member

## Re: Date difference customer orders

@Sofie

Calculate Max Order Date Per Customer using ALLEXCEPT and then calculate Datediff with today.

Time Since Last Order Date =

Var LastOrderDt = CALCULATE(MAX('P6:TimeSinceLastOrder'[OrderDate]), ALLEXCEPT('P6:TimeSinceLastOrder','P6:TimeSinceLastOrder'[CustomerId]))

Var TimeSinceLastOrderDt = DATEDIFF(LastOrderDt,TODAY(),DAY)

RETURN TimeSinceLastOrderDt

## Helpful resources

Announcements

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 169 members 1,774 guests
Recent signins:
Please welcome our newest community members: