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

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