Forum Discussion
Solved
highest value by category
Hi there
This is possibly what you are after?
Measure = CALCULATE ( SUM ( 'Table1'[StorageLevelAfterDelivery(kg)] ), FILTER ( 'Table1', 'Table1'[ShiftEndDate] = MAX ( 'Table1'[ShiftEndDate] ) ) )
7 Replies
- Hi there,
Could you please post some sample data and the expected outcome so that we can look at how to solve your current challenge?Hello Gilbert,
Here is an example of what I would like to do :
SiteName ShiftCode ShiftEndDate StorageLevelAfterDelivery(kg) A 23 20/07/2018 33 600 A 26 15/12/2017 34 300 A 30 08/03/2018 34 300 A 52 05/04/2018 34 300 A 37 30/01/2018 35 000 A 123 16/02/2018 35 000 B 45 15/12/2017 16 800 B 89 07/08/2018 32 900 B 95 15/03/2018 33 250 B 75 21/03/2018 33 250 B 78 27/02/2018 33 600 B 62 29/03/2018 33 600 C 54 15/12/2017 34 300 C 68 08/03/2018 34 300 C 145 05/04/2018 34 300 C 96 30/01/2018 35 000 C 102 16/02/2018 35 000 SiteName ShiftCode LatestShiftEndDate StorageLevelAfterDelivery(kg) A 23 20/07/2018 33 600 B 89 07/08/2018 32 900 C 145 05/04/2018 34 300 Thanks by advance
Hi JBG,
Create a measure using DAX as below:
LatestShiftEndDate = CALCULATE(MAX(Table1[ShiftEndDate]), ALLEXCEPT(Table1, Table1[SiteName]))
Regards,
Jimmy Tao
