DAX

Hello Aydan_Abdul,

Can you please try this:

CombinedRanges = 
VAR SortedTable = SUMMARIZE(FrequencyTable, FrequencyTable[id], FrequencyTable[freq_min], FrequencyTable[freq_max])
RETURN
GENERATE(
   DISTINCT(SortedTable[id]),
   ADDCOLUMNS(
      FILTER(SortedTable, [id] = EARLIER([id])),
      "CombinedFreqRange",
      IF(
         EARLIER(SortedTable[freq_max]) >= SortedTable[freq_min],
         MAXX(FILTER(SortedTable, [id] = EARLIER([id]) && EARLIER(SortedTable)[freq_max] >= SortedTable[freq_min]), SortedTable[freq_max]),
         SortedTable[freq_max]
      )
   )
)