Forum Discussion
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 c...
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
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!
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
