Need Help on creating weeks with months

[Anonymous]

Hi,

I am working on a data set where the date range is defined by the week number of the specific year. 

For example:

1) If its 202205,that shows week number 5 of the year 2022

2)If its 202332, that shows week 32 of the year 2023

Can you help me with craeting week range in the date column?

Thanks

[Ahmedx]

pls see this

https://community.fabric.microsoft.com/t5/Desktop/How-to-convet-year-week-number-to-date/m-p/3206612...

[Ahmedx]

pls try this

startweek date = 
var _year = VALUE(LEFT([Year-week],4))
var _week = VALUE(RIGHT([Year-week],2))
VAR _date = DATE(_year,1,-2)-WEEKDAY(DATE(_year,1,3))+_week*7
RETURN
_date-7

-----------------

Endweek date = 
var _year = VALUE(LEFT([Year-week],4))
var _week = VALUE(RIGHT([Year-week],2))
VAR _date = DATE(_year,1,-2)-WEEKDAY(DATE(_year,1,3))+_week*7
RETURN
_date

[Anonymous]

Can you please explain with a example. Do you need each month week number ? if you provide any example that would be better to understand