I calculated ISO week number in Power Query following instructions from Wikipedia. Here is how it goes. M code is at the end of this post. It all starts with weekday calculation. By default Power Query Date.DayOfWeek function returns a number between 0 and 6 starting from Sunday. To return weekday number according to ISO8601 … Continue reading How to calculate ISO week number in Power Query