Forum Discussion
Convert data from monthly format into weekly
1) in power query divided sales into daily sales and created a date in the same place
2) I created a calendar, if you don't like this calendar you can create your own
| Sr.No | Code | Jan23 | Feb23 | March23 | April23 | May23 | Total |
| 1 | 575 | 200 | 100 | 50 | 60 | 80 | 490 |
| 2 | 125 | 40 | 30 | 46 | 70 | 90 | 286 |
I have data in this monthly format.I want to convert it into weekly format without a date column.
Hi,
Remove the Total column. Select the first 2 columns, right click and click on "Unpivot Other Columns". Rename the Attribute column to Dae and ensure that this column has the Data Type of Date. Create a Calendar Table with calculated column formulas for Year, Month name, Month number and Week number. Create a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table. To your visual, drag the Month name and Week number column from the Calendar Table.
Hope this helps.
I don't have Date column in data.
In the Table that you have shared, the column headings are Month and year, When you Unpivot, the Attribute column's data type can be conveted into Date.
Thank yo so much. It works. But now how to divide that value of a month into weeks equally?
Hi,
I can try to help if you share the download link of the PBI file. In that PBI file, ensure that there is a Calendar Date with a week number column.