Convert from week number to month number

[Anonymous]

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.

[Anonymous]

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

[SpartaBI]

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

[SpartaBI]

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

[Anonymous]

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]

@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]

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 ? 

[SpartaBI]

Sure.

Not sure why you don't see it. Need to look at it. Do you want to do zoom ot teams?

[Anonymous]

If possible - sure

[SpartaBI]

Cool, ready now?

[Anonymous]

yes. can you give me details?

[SpartaBI]

https://us05web.zoom.us/j/86056168282?pwd=UktoQUdETXdMN2kzRzA0bGIyUXhsZz09

[Anonymous]

My zoom is installung. Please wait 3-5 mins if you could

[SpartaBI · Accepted solution]

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