DAX

Aydan_Abdul · ‎10-26-2023

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 · ‎10-26-2023

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

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)