Solved: Convert from week number to month number

Anonymous · ‎08-04-2022

Hello,

I have table with week number. How to convert it into month number? For example if I have in table week 2 then it should show month 1 ( as week 2 is in January). I tried hard, but I cant not find any solution.

Thank you in advance.

SpartaBI · ‎08-05-2022

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

View solution in original post

Anonymous · ‎08-04-2022

I have no date column in table. I have only 2 time columns: 1 with week number and second with year

SpartaBI · ‎08-04-2022

Can you share your table? Just copy paste it here or add a link to one drive / gdrive

SpartaBI · ‎08-04-2022

@Anonymous do you have the actual dates in your table?
Can you share your current table sample here?

Anonymous · ‎08-05-2022

Here is sample: I have w number + year. I would like to obtain column with month number and month name basing on existing week number. Ofc. there are only other weeks inside, not only w30.

SpartaBI · ‎08-05-2022

@Anonymous the thing is that weeks and months overlap..
A specific week can be part of two different months. So you can't do 1:1 to gregorian months. What is the logic you want to apply to that?

Anonymous · ‎08-05-2022

just 52 weeks divide per 12 minths. So it will be 4.33 week per month.

I also tried to gather time data into powerbi source. I extracted data from sql into sharepoint and I have additional column in csv file with exact time data. But when I refresh powerbi I dont see new column with time (I see only old columns). Is thi any way to make new column visible in PBI while connect powerbi with csv file with 1 additional column ?