How to make weekly data

[Jawad007]

Hello,

So I have a date column in my table; however, I need to create a measure or column that gives the week number of every month and resets every month. For example, the first 7 days in june correspond to 1, and the next 7 days correspond to 2 (week 2). I have been trying to figure this out for a long time, but with no hope and I am a beginner in the software. I would really appreciate your help, thank you!!

[mlsx4]

Hi @Jawad007 

It is easier than you think. 

Go to Power Query Editor and select the date column. Now navigate to the Add column tab> Date>  Week > Week of the month

[Jawad007]

Hlelo @mlsx4 

Ohhh, I cannot believe it was this simple. I cannot thank you enough! Do you know if it is possible to make the week 6 days rather than 7? If not, no worries!

[mlsx4]

Hi!!

As far as I know there is nothing to do it easily... but maybe there is a possibility to create something. I will check it