Hi all, I would like to consult a formula in Power query, I have extracted my source data with weeknum, as some of Jan 1 is connected with the 31/12 last year, my system will make them as week 53, how could I use the formula to detect if I have week 53, then it will change to week 1 and actual week 1 will change to week 2 and so on, of cause, if that is no week 53, it will follow the original weeknum, thanks
