days since last order

[ajve22]

Hi, 

My model has 3 tables Sales, Date and Customer. Sales table has relationship with Customer and Date.

I want to calculate customer wise no. of days since they given their last order. I tried few measures to calculate the last order date but they are giving future date as my date dimenison has future dates.

MAXX( FILTER( 'Date','Date'[Sales order date] <= TODAY() ), 'Date'[Sales order date])

LASTDATE('Sales order date'[Sales order date])

please suggest how to get this.

Thanks

[ajve22 · Accepted solution]

Hi,

This was due to single cross filter direction from date to sales table. Here trying to slice the date with customers, so setting up cross filter direction as both solved the problem.

thanks

[PC2790]

I see that you are picking the columns from Date Table though it should be:

LastOrderDate=MAXX( FILTER( 'Sales','Sales'[Sales order date] <= TODAY() ), 'Sales'[Sales order date])

or 

LastOrderDate = LASTDATE(Orders[OrderDate])

This should give the right result.

If you are looking for something else, please shout out