Start counting week from a fixed date

Hi AjaySingh 

Weeknum() returns a fixed value, so try another way, 

e.g. 

Steve  join date:2021/9/1,
week1:2021/9/1-2021/9/7,
week2:2021/9/8-2021/9/14,
week3:2021/9/15-2021/9/21,
...

Weeknum = 
    var _joinDate=DATE(2021,9,1)
    var _duration=DATEDIFF(_joinDate,MIN('Table'[Column1]),DAY)
return INT(_duration/7)+1

result

Best Regards,

Community Support Team _Tang

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