Forum Discussion

JBG's avatar
JBG
Regular Visitor
8 years ago
Solved

highest value by category

    Hello everyone!! I am trying to extract the data from the latest date record (ex: for each customer last delivery date & delivered quantitiy) I am able to select the last date but I get...
Need Help
  • GilbertQ's avatar
    GilbertQ
    8 years ago

    Hi there

     

    This is possibly what you are after?

     

    Measure = 
CALCULATE (
    SUM ( 'Table1'[StorageLevelAfterDelivery(kg)] ),
    FILTER ( 'Table1', 'Table1'[ShiftEndDate] = MAX ( 'Table1'[ShiftEndDate] ) )
)

JBG's avatar
JBG
Regular Visitor
8 years ago

Hi Jimmy,

 

Thanks for your answer. Unfortunatley, I still have the same problem which is it doesn't filter one data (the latest) per site name. When I wwant to know quantities per site at the latest date, I still have several datas per site... If you have another advice... Thanks

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago

Hi there

 

This is possibly what you are after?

 

Measure = 
CALCULATE (
    SUM ( 'Table1'[StorageLevelAfterDelivery(kg)] ),
    FILTER ( 'Table1', 'Table1'[ShiftEndDate] = MAX ( 'Table1'[ShiftEndDate] ) )
)

  • JBG's avatar
    JBG
    Regular Visitor
    8 years ago

    Hello everyone,

     

    Thanks for your help. After I tried each of your solutions, it worked with the first one and then I filter the table with maxdate = 1.

     

    Thanks a lot.

     

    See you

     

    Jerome

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      8 years ago
      Glad you got it working