Forum Discussion

nisansala23's avatar
nisansala23
New Member
3 years ago

Get the highest value from selected date range

Hi, I'm trying to get the highest value from a date range. below I have mentioned my dax code. it only returns the value related to slicer end date, not the highest value of the date range. Can anyo...
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi nisansala23 
Please try

HIGHEST_ASPI_VAL =
MAXX (
    DATESYTD ( 'Date'[Date] ),
    CALCULATE ( MAX ( BI_SECTOR_HISTORIES[SECTORIAL_INDEX] ) )
)