Forum Discussion

Jawad007's avatar
Jawad007
New Member
3 years ago

How to make weekly data

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!!

3 Replies

  • mlsx4's avatar
    mlsx4
    Memorable Member

    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's avatar
      Jawad007
      New Member

      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's avatar
        mlsx4
        Memorable Member

        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