Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Last Date Order

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 ord...
Need Help
Show and Tell
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Thank you for your solution. 

 I works now!! 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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!!