Create bucketing column based on month_year column

[SBC]

Hi,

I have month-year column(jan-2023) in a table.we need to create a two columns one is column1 and column2.

Month_Year

Jul-22

Aug-22

Sep-22

Oct-22

Nov-22

Dec-22

Jan-23

Feb-23

Mar-23

Apr-23

May-23

Jun-23

Jul-23

Aug-23

Sep-23

Oct-23

Nov-23

Dec-23

Jan-24

Feb-24

Mar-24

Apr-24

May-24

Jun-24

Jul-24

Aug-24

Sep-24

Oct-24

Nov-24

Dec-24

Jan-25

Feb-25

Mar-25

Apr-25

May-25

Column1 one we need to generate the seires as shown below: Current month starts with series from 0 and so on….,if the current month is may  should show it as 0 next month as 1………….

Expected1:

Column2:

We  need to create a second column (Column2) as bucketing based on column1 we neeed to do bucketing  0-1,2-5,6-11,12-23,24+

Expected output:

Thanks,

SBC

[johnt75 · Accepted solution]

Firstly, make sure that your year month column is actually a date, you can control the visual output by using the format string. You can then add the first column like

Column 1 =
DATEDIFF ( TODAY (), 'Table'[Year month], MONTH )

and you can use the static segmentation pattern to calculate column 2.