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] ) )
)

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi JBG,

 

Create a measure using DAX as below:

LatestShiftEndDate = CALCULATE(MAX(Table1[ShiftEndDate]), ALLEXCEPT(Table1, Table1[SiteName]))

  

 

Regards,

Jimmy Tao

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
    Super 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
        Super User
        8 years ago
        Glad you got it working