Forum Discussion

Aydan_Abdul's avatar
Aydan_Abdul
New Member
2 years ago

DAX

Hi,everyone! I have DAX problem.

I have frequecy table.
My input table is this.
id                freq_min    freq_max
136
1610
11018
11820
12123
235
2510
21113

I want this:
 id            freq_min      freq_max
1320
12123
2310
21113
3-6 ; 6-10; 10-18; 18-20 ---》2-20
They are ranges and I combine ranges.

With loves

Need Help

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    2 years ago

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