DAX

[Aydan_Abdul]

Hi,everyone! I have DAX problem.

I have frequecy table.
My input table is this.
id                freq_min    freq_max

1	3	6
1	6	10
1	10	18
1	18	20
1	21	23
2	3	5
2	5	10
2	11	13

I want this:
 id            freq_min      freq_max

1	3	20
1	21	23
2	3	10
2	11	13

3-6 ; 6-10; 10-18; 18-20 ---》2-20

They are ranges and I combine ranges.

With loves

[Sahir_Maharaj]

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

[Aydan_Abdull]

Syntax is wrong. Thanks a lot!