Forum Discussion
Solved
Convert week numbers into months
Hi. How do I convert week values into months? Note, the original data is not a date, simply a value specifying the fiscal week. I would like to know how to convert these weeks into months e.g. week 1...
- You should build a dimensional model. https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/
- Get a calendar table that does contain dates. https://exceleratorbi.com.au/power-pivot-calendar-tables/
- you can keep your surrogate date key (the one you mention) in the data table as long as it also exists in the calendar table as long as it also exists in the cake dar table (for the join) you need to use “mark as date table“ from the modelling menu if you join on a surrogate key.
- You can learn how to build a calendar table here
https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/
- You should build a dimensional model. https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/
- Get a calendar table that does contain dates. https://exceleratorbi.com.au/power-pivot-calendar-tables/
- you can keep your surrogate date key (the one you mention) in the data table as long as it also exists in the calendar table as long as it also exists in the cake dar table (for the join) you need to use “mark as date table“ from the modelling menu if you join on a surrogate key.
- You can learn how to build a calendar table here
https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/