undefined

Hi Anonymous ,

• 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/

I have also found a similar post, please refer to it to see if it helps you.

Solved: Convert from week number to month number - Microsoft Power BI Community

check this article:
https://www.daxpatterns.com/week-related-calculations/

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.