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 anyone help me to figureout the issue

 

HIGHEST_ASPI_VAL =
var _year = SELECTEDVALUE('DATE'[YEAR])
var _yearstart = DATE(_year, 1, 1)
var _endDate = SELECTEDVALUE('DATE'[Date])
var ASPI_VAL = CALCULATE(MAX(BI_SECTOR_HISTORIES[SECTORIAL_INDEX]),
    FILTER(BI_SECTOR_HISTORIES,BI_SECTOR_HISTORIES[SECTOR_DATE] >= _yearstart
        && BI_SECTOR_HISTORIES[SECTOR_DATE] <= _endDate))
var Result =
IF(
    NOT( ISBLANK(
        SUM(BI_SECTOR_HISTORIES[SECTORIAL_INDEX]))),
        ASPI_VAL, BLANK())
        return
        Result

2 Replies

  • 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] ) )
)
  • BrianConnelly's avatar
    BrianConnelly
    Resolver III
    3 years ago

    If you are trying to get the highest value within a selected date range, try using the Allselected...

    var ASPI_VAL = CALCULATE(MAX(BI_SECTOR_HISTORIES[SECTORIAL_INDEX]),
  ALLSELECTED(BI_SECTOR_HISTORIES[SECTOR_DATE]))