Date time Analysis

Question

Hi Everyone ,

I have daily sales data  from 2019 to 2021.

I want to do check for trend/pattern that how the sales is behaving in the first week of every month and last week of every month.

how I can convert that daily sales and also how to extract only 1st week of every month  ?

Please suggest some ideas to do that.

For example data representation:

Date Daysales03-01-2019Friday1000003-02-2019Saturday600003-03-2019Sunday500003-04-2019Monday850003-05-2019

Tuesday932003-06-2019

Wednesday450003-07-2019

Thursday6888

Rohitpatil7 · Accepted Answer

Hi @ash25sumbre, Try using below formula to get week number which resets every month. I am sure this will help you to find 1st week of every month

1 + ToNumber(DateTimeFormat([date],"%W")) -
ToNumber(DateTimeFormat(DateTimeAdd([date], 1 - ToNumber(DateTimeFormat([date],"%d")),"days"),"%W"))

ash25sumbre · Accepted Answer

Hi @Rohitpatil7 ,

Thank you .

But then how I will group this every  first week sales  for different months ? please help me with this too