Month number up to 36 months

v_mark — Tue, 13 Apr 2021 16:14:58 GMT

Hi,

I do have a date table that has Month number 1 -12. I'll be needing to have a Month number that is up to 36 months

from there I will calculate the running total. My problem is I don't know how to extend those Month numbers up to 36.

Is there a way to extend the month number perhaps adding an additional column in my date table?

Expected results below

Re: Month number up to 36 months

amitchandak — Tue, 13 Apr 2021 04:26:01 GMT

v_mark , after 12 months data is repeating, what is the advantage of 36 months

v_mark — Tue, 13 Apr 2021 16:15:44 GMT

I updated the view above. I just realize that just the number of months will do and yes my bad the example above is just used as a representation.

pretty much a running total for 36 months that has an indicator on the left side 1-36