How to split the date to aging slots like from 1 to 3 months, from 3 to 6 months, from 6 to 12 month

[Mohamed_Samir]

Hello all,

i have a date field and i need to analyze the data by aging slots like:

1- from 1 to 3 months.

2- from 3 to 6 months

3- from 6 to 12 months.

4- Greater than 12 months.

I know i can use group to perform that, but i need to use formula to get updated automatically.

Your support is highly appreciated.

Thank you,

Mohamed Samir.

[eliasayyy · Accepted solution]

hello please use this 

Group = 
SWITCH(
    TRUE(),
    'Table'[Date] <= TODAY() && 'Table'[Date] >= EDATE(TODAY(),-3), "1 to 3 Months",
    'Table'[Date] <= EDATE(TODAY(),-3) && 'Table'[Date] >= EDATE(TODAY(),-6), "3 to 6 Months",
    'Table'[Date] <= EDATE(TODAY(),-6) && 'Table'[Date] >= EDATE(TODAY(),-12), "6 to 12 Months",
    'Table'[Date] < EDATE(TODAY(),-12) , "Greater than 12 Months"
)

[Mohamed_Samir]

Thank you very much, it is working with me.