Hi All,
I am trying to convert weeks into months. I have weeks from 1 to 52 and I want them to convert into months from 1 to 12 but I condition if the weeks split into two months like week 5 is splitting into Jan & Feb in that case the week should fall into that month where more days are coming like for week 5 - 3 days are coming in jan month & 4 days are coming into feb so it should be considered into Feb month and same logic should be added to rest of weeks & month.
I am using this calculation right now - DateTimeFormat(DateTimeAdd(ToString([Year])+'-01-01',[Week (2023)]*7-1,'day'),'%m') but it is not giving me the desired result.
Looking forward for some positive response.
