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...
BrianConnelly's avatar
BrianConnelly
Icon for Resolver III rankResolver 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]))