topic Get the highest value from selected date range in DAX Commands and Tips

Get the highest value from selected date range

nisansala23 — Sun, 12 Mar 2023 17:06:01 GMT

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

Re: Get the highest value from selected date range

tamerj1 — Sun, 12 Mar 2023 17:49:35 GMT

Hi nisansala23
Please try

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

Re: Get the highest value from selected date range

BrianConnelly — Sun, 12 Mar 2023 22:39:33 GMT

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