undefined

[Anonymous]

I have a weeknumber without date table ,how to convert week number to month number

[Anonymous · Accepted solution]

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.

[ronaldbalza2023]

Hi @Anonymous , hope you are having a great day. I was wondering, how did you get the week number without a reference? Have you typed it manually? If so, I would suggest having a date table as it will help you quickly achieve what are you trying.

Creating The Ultimate Date Table In Power BI - How To Do This Fast (Updated Code) 
The Fastest Way To Create A Comprehensive Date Table Within Your Power BI Models