We heard from European friends that they aren't fans of the N American week numbering systems. 📆 #PowerQuery has a “week number” function but no function to get ISO weeks. Well, our Monkey Tools #Excel add-in will inject a GetISOWeek function.✋ Learn how it works here: mkyt.ca/get-iso-week
![Untangling ISO Weeks Into a Real Calendar
Ken Puls built a student a quick custom Power Query function that unpacks any ISO week into real calendar dates. From there, he expanded the calendar to add other key periods for dimensional reporting.
Screenshot of the Power Query editor with a table with 2 columns: Week ID (containing the ISO week codes) and Date (containing Lists). The formula bar contains the following function:
=Table.AddColumn(#”Removed Columns”, “Date”, each fnISOWeekIDToDates ([Week ID]))
Below the table is one of the expanded Lists containing the calendar dates for the corresponding ISO week code.
(Skillwave Training logo)](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:xpiehblln2cworixrwklvoyv/bafkreiduatpnh4qcribdox3j23omvhouaiz6ckebkxw574l3pq26ednu7a)
