Last Date Order

[Anonymous]

Hi, 

I tried to get the last Date of order of each Customer ID by using formular : LASTDATE()

Last Date Purchaes = LASTDATE(Orders[Order Date].[Date])

but it gave me the duplicate last date of order of each customer id. 

here is the result: 

the data set using is: sample_superstore. 

Hope to hear from you. 

thanks!!

[Zubair_Muhammad]

Hi @Anonymous 

In the picture it seems you added this formula as calculated column

Use a MEASURE instead

Measure = LASTDATE(Orders[Order Date])

or

Measure = MAX(Orders[Order Date])

[Anonymous]

Hi,

Thank you for your solution. 

 I works now!! 

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Yes, You can not use a MEASURE in SLICER

But you can add a calculated column as follows. Then use it in slicer

Column = CALCULATE(max(Orders[Order Date]),ALLEXCEPT(Orders,Orders[Customer ID]))

[Anonymous]

Dear, Thank you for your solution. 

I can use slicer now. but one thing happen is the user id is duplicated. 

I dont know why. Could you help me to check it, please? 

Here is the sample file that I use. 

https://we.tl/t-56Q7qWkro5

Thanks and hope to hear from you!!