Time calculations

[Bobbys]

Hi,

I'd like to calculate window-over-window change in my report. 

There are three windows, January, February and July.

The january window is only January, February window is between Feb 1st tot June 30th, July window is between July 1st and December 31st.  I want to compare these windows to the previous years, as well as to be able to compare the months in the respective window to the same month the year before. 

Window	Total Sales	Total sales previous period (2021)
2022-JAN	1 000	800
January	1 000	800
2022-Feb	500	1000
February	100	200
March	100	200
April	100	200
May	100	200
June	100	200

Due to these windows having different lenght, I haven't really been able to crack how to set up my time intelligence accordingly. 

Any help would be very appreciated

[Anonymous · Accepted solution]

Hi @Bobbys,

I'd like to suggest you use the date function to extract the current date as a variable to calculate the previous date ranges, then you can simply use these 'date ranges' as conditions to filter on your table to get corresponding results. (date function does not require a calendar table and can simply nest and custom the filter ranges)

Time Intelligence "The Hard Way" (TITHW)  

Regards,

Xiaoxin Sheng